Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: yes/no field


Message #1 by "Ken" <ken.mcintosh@s...> on Thu, 1 Feb 2001 10:45:58 -0000
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

Message #2 by dholloway1@a... on Sun, 4 Feb 2001 14:58:21 -0000

  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


  Return to Index