Claudine: >>> This way if my user types houstn, (1) he doesn't have to backspace and change it to Houstn or some other misspelled version because he's in a hurry, (2) the forced text will be HOUSTN and I can check it against the existing list and (3) I can correct it on the fly if necessary. <<< I am pretty sure that houstn or Houstn or HOUSTN will not match HOUSTON...unless you use the SOUNDS operator (LOL) ;) Javier,
P.S. I am going to guess that Houstn is the code for Houston in your line of work? Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Claudine Robbins Sent: Wednesday, November 02, 2005 11:25 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Format Mask Very good ideas Dennis! My own idea though is to control the entry and the spelling while simplifying entry for the user. This way if my user types houstn, (1) he doesn't have to backspace and change it to Houstn or some other misspelled version because he's in a hurry, (2) the forced text will be HOUSTN and I can check it against the existing list and (3) I can correct it on the fly if necessary. ~Claudine :) > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis > McGrath > Sent: Wednesday, November 02, 2005 11:07 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Format Mask > > Claudine, > > Perhaps the format mask is not the right solution. > I'm new to 7.5 but my old standby was to put an expression in the form: > Colname = (LUC(colname)) > The user could enter the data in any case but upon exiting the field it > would be forced to upper case. > > On another note, I have pretty much standardized on allowing mixed case > in address fields, and only forcing the address to upper case when > printing envelopes or labels. > This gives you the best of both worlds. The address can be mixed case > in the body of a letter but upper case on the part the USPS deals with. > > Dennis McGrath > > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine > Robbins > Sent: Wednesday, November 02, 2005 10:53 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Format Mask > > Cool, now how do I enter Oklahoma City? (format mask will not allow the > space). > > Claudine > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. > > Razzak Memon > > Sent: Wednesday, November 02, 2005 8:46 AM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - Re: Format Mask > > > > At 06:03 PM 11/1/2005, Claudine Robbins wrote: > > > > >I'm trying to force caps to be entered into two 15 and > > >2 character dbedit fields. > > > > > >I've tried these and although they allow me to enter only upper case > > >letters, they won't let me get out of the field.... > > > > > > >AAAAAAAAAAAAAAA<;0;_ > > > >AAAAAAAAAAAAAAA;0;_ > > > >A;0;_ > > > > > > Claudine, > > > > Here's how: > > > > You need to use the following format mask: > > > > >aaaaaaaaaaaaaaa<;0;_ > > >aaaaaaaaaaaaaaa;0;_ > > >a;0;_ > > > > In your case, you have forced the user to enter all 15 characters (all > > > capital). User MUST enter 15 characters before leaving the field. > > > > Using the format as "aaaaaaaaaaaaaaa", all letters will still be > > capital but the user can only enter a few characters and is not > > required to enter all 15 characters before leaving the field. > > > > That's all there is to it! > > > > Enjoy and make sure to have fun. > > > > Very Best R:egards, > > > > Razzak.
