Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2003

Georgia has attended:
Access Introduction course

Access

Hello,

Will it be possible to have a tick box or a drop down box on a Access table. If so whats the process for doing so?

Thanks.

RE: Access

Hi Gerogina

Thanks for your question

First create your table with the relevant text field together with the required "yes/no2 fields.

Then create your form with the text box in the leftmost position and the check boxes for the yes/no fields arrayed along side it to the right.

Finally in the forms property sheet set the default view to datasheet

Hope this helps

Regards

Stephen

Mon 26 Oct 2009: Automatically marked as resolved.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.