Claudine: You are correct about the zip code not giving you the correct city; in fact, they give you the postal district. In the Kansas side of Kansas City, we have 20+ cities and most of those, when the zip code is entered, return "Shawnee Mission" when actually, there is no such city. It obviously works for mail delivery as they only care about the zip code and not the city, but it is useless for other deliveries that require an actual city. Javier,
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 3:59 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Format Mask 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. > > > >
