Hello,
I have a large database with yes/no field in a table. I would like to
show a tick in the box of the yes/no field. I have set the default value
to TRUE still does'nt work.
Any ideas..
Thanks
Ken
If it is a database you are modifying, it will not change the existing
records. You must do that with an Update query. If you put default to YES
on a Yes/No field, all new records should show a tick mark. One more
thing to check is what is the default set to for the data entry FORM when
you bring it up. If is is set to NO and you add a record via the form and
not the table, this setting will override the table default.
Dennis