Validating text entered is all lowercase

[jonesy17]

I need to ensure that all text entered in field Userid is all lowercase.

myuserid = good

myUserid = bad

myuserID = bad

myuSeRiD = really bad

... you get the idea.

I've tried validating by calculation Lower(Userid) but that doesn't seem to do anything. I've also tried If ((Lower(Userid), 1, 0) but that got me into real trouble after I made it strict and didn't seem to work anyway.

I've also tried searching the forums but I must not be looking for the right thing because I'm coming up with nothing.

Can anyone help?

[stanley]

Robert:

If there is a point where you can have a script kick in (after a form with the Userid is filled in, for example) then you could stick this script step in there:

Set Field ("UserId", "Lower(UserId)")

This would strip out the uppercase characters from the entry.

-Stanley

[jonesy17]

So how do I run a script after the operator has tabbed out of the Userid field?

[stanley]

You can't launch a script on someone hitting Tab, but if you've got a "Finish" button on there or something, you could put the script step in there. Or, you could run the script on all the records, when the user closes the database... lots of places to put it in there, depending on your design.

-Stanley

[Charles Delfs]

IF you just want to validate try:

Exact(MyField,Lower(MyField)

Charles

[jonesy17]

Cheers, Charles. That's "exact"ly what I was looking for! *Groan*