entering yesno field check
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Entering a yes/no field as a check box on a table and form

Entering a yes/no field as a check box on a table and form

resolvedResolved · Urgent Priority · Version 2007

replyReply Tue 18 Nov 2008, 10:43Delegate Susan said...

Susan has attended:
Access Introduction course

Entering a yes/no field as a check box on a table and form

I am working on a existing database I did not create. I can view it as a datasheet or in form view and design view. My aim is to add 3 checkboxes to the database to record yes or no to signify implementation of 3 different options.

I have created new fields by going to datasheet view, edit table. Now I can not work out how to format them as yes/no data. My plan was to do that then add then to the design view and from what I understand the default design view format for a yes/no field would be a check box.

I can format the new field I created by dragging it into the design view, right click on it, select properties, change format to yes/no. I then tried right clicking on the formatted field in the design view to chnage it to a check box but the option could not be selected.

I have tried just clicking on the check box icon on the ribbon and dragging a box onto the form but then when I check the box on one record it checks the box for evey record and vice-versa.

What is the best way to proceed? Thanks.

For upcoming training course dates see: Pricing & availability

 

Please browse our web site to find out more about
access courses in london and other Microsoft training courses.

Access tip:

Modal forms

If you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard