T
Tom Wickerath
Hi Larry,
When you enter "" into a field (with zero-length strings
allowed), you get a zero length string (ZLS). A ZLS is NOT
the same as null. You can prove this to yourself by
running a query, and setting the criteria for this field
to either Null or "".
Null means that a value is unknown. ZLS is used when you
know that a value does not exist. For example, if a
customer does not have a facsimile machine, a ZLS entry
means "I know that this customer doesn't have a fax
machine". On the other hand, a null in this field would
mean "I don't know if this customer has a fax machine".
To the best of my knowledge, you cannot enter "" into the
display. I'm not sure why you would want to.
Tom
____________________________________
Currently when I enter "" (with zero-length strings
allowed) into a text field in Access 2003 and leave the
field, the "" disappears. I think it turns it into a null
value. How can I get the "" to continue to show in the
field?
When you enter "" into a field (with zero-length strings
allowed), you get a zero length string (ZLS). A ZLS is NOT
the same as null. You can prove this to yourself by
running a query, and setting the criteria for this field
to either Null or "".
Null means that a value is unknown. ZLS is used when you
know that a value does not exist. For example, if a
customer does not have a facsimile machine, a ZLS entry
means "I know that this customer doesn't have a fax
machine". On the other hand, a null in this field would
mean "I don't know if this customer has a fax machine".
To the best of my knowledge, you cannot enter "" into the
display. I'm not sure why you would want to.
Tom
____________________________________
Currently when I enter "" (with zero-length strings
allowed) into a text field in Access 2003 and leave the
field, the "" disappears. I think it turns it into a null
value. How can I get the "" to continue to show in the
field?