can't assign NULL

  • Thread starter Thread starter mcnews
  • Start date Start date
M

mcnews

is there some reason why the following line of code creates a "Value
you entered isn'tvalid for this field" error in Access 2000?
Form.CasminoAdded = Null

i do get the error with Access 2003.
 
is there some reason why the following line of code creates a "Value
you entered isn'tvalid for this field" error in Access 2000?
Form.CasminoAdded = Null

i do get the error with Access 2003.
Click to expand...

it's a Yes?No boolean field.
 
I wouldn't use a yes/no field if I wanted to store Null. An int field would
be more appropriate.

Also, we have no idea what "Form.CasminoAdded" is.
 
I wouldn't use a yes/no field if I wanted to store Null. An int field would
be more appropriate.

Also, we have no idea what "Form.CasminoAdded" is.
Click to expand...

i explained that it is a Yes/No boolean field.
users need to be able to check yes or no or set it to null.
null is not regarded as the same thing as no.

anyways, the problem was that it was trying to assign a value when the
control was disabled.
so it's fixed now.
 
Back
Top