M
mjones
Hi All,
My staff keeps copying and pasting text into form fields from emails
and such with trailing and leading spaces, e.g. on email addresses.
Obviously, this is junk data.
Is there a way to on exit or the like, check for leading and/or
trailing spaces and give an error until they fix it?
Something like -
If Me!EmailP "STARTS OR ENDS WITH A SPACE" Then
MsgBox "Email cannot start or end with a space'"
Cancel = False
End If
Hum, probably not that simple, but one can hope.
Thanks a bunch,
Michele
My staff keeps copying and pasting text into form fields from emails
and such with trailing and leading spaces, e.g. on email addresses.
Obviously, this is junk data.
Is there a way to on exit or the like, check for leading and/or
trailing spaces and give an error until they fix it?
Something like -
If Me!EmailP "STARTS OR ENDS WITH A SPACE" Then
MsgBox "Email cannot start or end with a space'"
Cancel = False
End If
Hum, probably not that simple, but one can hope.
Thanks a bunch,
Michele