That's a great idea Bernie, except my users do not have access to zip codes, they are entering city, state for each a "from" and a "to" locations.
Although, I should note that when I give my zip code to someone, 77479, they do NOT come up with Sugar Land but Dewalt, Texas, so maybe that system is not perfect either... > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis > Sent: Wednesday, November 02, 2005 3:34 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Format Mask > > Claudine, > Why not enter the zip code first and then from your zipcode table that > contains the city names, you can just pop in the correct name so the user > doesn't have to type it. > You can get a complete zipcode list containing all the U.S. zipcodes along > with their city, state and county codes. www.zipwise.com I think it > costs > $15.00 > I got it a year ago and find it very useful. > > Bernie Lis > > ----- Original Message ----- > From: "Claudine Robbins" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Wednesday, November 02, 2005 1:12 PM > Subject: [RBG7-L] - Re: Format Mask > > > > 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. > > > >
