null value

  • Thread starter Thread starter _eric clapton
  • Start date Start date
E

_eric clapton

I have a char field which I check the "allow null" property and when I tried
to input an empty string that field, it always give me the following msg:

"You tried to assign Null value to a variable that isn't a Variant data
type"

But if I run it in an update query and I don't get the same message. I am
using SQL2000 and access 97 query. Please help. Thanks.
 
_eric clapton said:
I have a char field which I check the "allow null" property and when
I tried to input an empty string that field, it always give me the
following msg:
"You tried to assign Null value to a variable that isn't a Variant
data type"

But if I run it in an update query and I don't get the same message.
I am using SQL2000 and access 97 query. Please help. Thanks.
Click to expand...

You can't input a zero-length string from the GUI because Access automatically
strips trailing blanks. The append query doesn't do this which is why it works.
 
Back
Top