Andreas wrote: > For US ZIP codes in a database you could define a fixed text field with 5 > characters and access the field through a pattern field on a form to accept > digits only.
Make that "#####-####" or "#####-####-####". If you are using bar codes on your snail mail, you need that thirteen digit US ZIP Code. In theory, all you need is the name of the recipient, and the 13 digit bar code. jonathon > Better: A list box bound to a list of all known US ZIPs with city names. > Then you would get the city name automatically. > > In a spreadsheet this could be achieved by means of data validation with > VLOOKUP, but like all spreadsheet solutions, this is difficult to > maintain and breaks with copy/paste actions. > > Andreas S. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
