Yes, I think it'll solve missing records on lookups because the city name is misspelled. At least that was the original goal but with the power of R:Base 7.5 and -dare I say it?- the property command (don't tell Razzak, I might get a "second" award for abusing it next year!), we can do anything...
> -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis > McGrath > Sent: Wednesday, November 02, 2005 11:41 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Format Mask > > 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.
