Validate Invisible characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Kimmy said:
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?
Click to expand...


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.
 
Back
Top