Yes/No - 1

R

Richard

Changing the Default Value in this field to -1 still did
not put checks in the boxes. They all still default to
No. Help!

Thanks
 
D

Douglas J. Steele

You do realize that setting the default value will only affect new rows.
Existing rows will have whatever value is assigned to the field bound to the
check box.
 
J

John Vinson

Changing the Default Value in this field to -1 still did
not put checks in the boxes. They all still default to
No. Help!
Click to expand...

Setting the Default will not affect records already in the database,
only newly added records. If you want to update all the FALSE entries
in your table to TRUE, run an Update query.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replacing Checkbox Value 1
Access how do you set a yes/no data type as required? 0
Yes/No data field help 1
update yes / no field in table based on another table 3
yes/no for old data 4
Yes/No combo box 5
Expression As Default Value in Control Properties 2
Queckbox to text 1

Top