Nice! So the user enters the city name in all upper case and you fix it from a list. If there are any entries still in UPPER, you can find them and update your list.
Dennis McGrath -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On 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.
