Zero Length String

A

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
 
D

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 ="";
 
J

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").
 
Top