Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Edit Masking

Status
Not open for further replies.

CESHRPR

Programmer
Aug 1, 2002
23
US
I'm new at this and could use some help with edit masking.

First, I want to verify that I am doing something correctly. I have a parameter to be entered that should be upper case, all letters (although the default is '*') and must be at least three characters but not more than 5. I have >&&&CC. Is that correct? I was using L to force a letter, but I don't think that will work because of the default.

Also, I want anything the user enters to be changed to uppercase. Can I just put a'>' in the masking field on the parameter default screen? It seems like it insists on specifying the field lengths on each. This is a pain for fields that are 30 characters in length.

Suggestions? Thanks.
 
The > only specifies that the following will be uppercase, you have to enter enough characters. I agree that its a pain, it also looks very tacky if you use the default parameter interface.
Andrew Baines
Chase International
 
What about applying the Uppercase function to your parameter in the record selection statement?
 
Thanks, but actually that UC formula in the select is exactly what I'm trying to avoid. I'd much rather do it through the edit mask.

Only one question remains for me. That one above, where I defined it as >&&&CC will allow a single character when entered. Shouldn't that mask force a minimum of three characters? Any ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top