yes/no for old data

  • Thread starter Thread starter LindaSD
  • Start date Start date
L

LindaSD

I want to add a yes/no field but don't want my old data to have a value in
this field only newly entered data to have the user make the selection. When
I add the yes/no type field, even with no default value, it adds no to all
the old data. The default comes up 0 and then it also fills in all the old
data with 0. This makes reporting a mess since "no" is not necessarily
correct on the old data and I will not be going back in the old data to find
the correct answer. I want the old data to just stay blank for this field.

Do I have to just make a text field with a lookup for yes/no so that it
leaves the old data blank and going forward have the user complete the field?
 
You can use an integer field with no default value.

Then you can store
Null, zero, or -1 in the field.

On your entry form, you can (if you wish) set the default of a checkbox to 0.
Also a checkbox bound to an integer value can be set to Triple-State (True,
False, and Null) When it is null the checkbox will be grayed out.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
What are you trying to accomplish by posting the word "REMOVE" to this
newsgroup? In this context, it does nothing at all. Perhaps there is another
way to accomplish what you want.

Larry Linson
Microsoft Office Access MVP
 
Back
Top