null value

[_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.

 

[Rick Brandt]

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.

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.