Default

P

Pammy

Access 2003
I have a form with a total of 30,000 records. I want to add on to my drop
down "Incoming Evidence" and make this a default. Question, if I do this and
some of the records that are already entered but this field is blank, will
they still stay blank? I do not want this field in my records that is blank
to reflect what I have made a default. I wasn't sure a default choice would
auto field in where there is a blank in previous added records.

Thanks,
 
J

John Spencer

Defaults only apply to new records, so if the combobox is bound to a field you
will not change any records.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

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

Multiple Selection Criterial Query some with NULL fields 5
Hiding the default record 5
Shrink 3
yes/no for old data 4
subform filter 7
Filter By Selection error for blank fields 2
combobox blank 1
How can I avoid NULLs by default? 3

Top