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.
