Validate Invisible characters

[Guest]

Hi,
In my form, I have a memo field which is not allowed to be empty or spaces.
However, one user has used ALT+255, it is just like a space, I called it an
"invisible" character. Validation with either length=0 or empty or space does
not work. How can I validate this field?

Thanks in advance. I am new in Access.

Kimmy

 

[Marshall Barton]

In my form, I have a memo field which is not allowed to be empty or spaces.
However, one user has used ALT+255, it is just like a space, I called it an
"invisible" character. Validation with either length=0 or empty or space does
not work. How can I validate this field?

Compare it to Chr(255)

But it seems to me there is a user interface deficiency
somewhere that's making a user go to all the trouble of
entering such a wierd value. The next thing they'll start
doing is enter a bit of nonsense just to get past your
attempt to force them to enter something they are
obviously(?) not prepared to enter.