Zero Length String

[Allison]

This seems like such a silly question....but how do a
change the field value in a record from a zero length
string back to null?

Is there some kind of shortcut for users when they are
entering a zero length string?

Thanks for your help. Allison

[Duane Hookom]

I'm not sure how a user could enter a zero length string other than through
code. What makes you think the field contains a zls? YOu can run an update
query:
UPDATE tblYourTable
SET fieldA = Null
WHERE fieldA ="";
--
Duane Hookom
MS Access MVP

Post by Allison
This seems like such a silly question....but how do a
change the field value in a record from a zero length
string back to null?
Is there some kind of shortcut for users when they are
entering a zero length string?
Thanks for your help. Allison

[Jeff Boyce]

Allison

Are you asking how YOU can enter a null, or how the "users" can enter a
null?

What's the AllowZeroLengthString property set to for this field in the
underlying table?

Why do you need to change it? What would happen if you just left the zls's?

If you leave a field empty (nothing in it, ever), it has no value (i.e.,
should be "Null").