Jump to content

Validating text entered is all lowercase


This topic is 6538 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6538 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.