Yes, I'm experimenting with sounds and it works very nicely. We're actually entering city names <g>
> -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier > Valencia > Sent: Wednesday, November 02, 2005 11:36 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Format Mask > > 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.
