Results 1 to 5 of 5
  1. #1
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754

    Address formats in data bases? Suggestions ?

    Hi all,
    I am wondering if anyone can recommend any suggestions on address formats in forms. I don't deal a lot outside of USA but every now and then I end up with mail to Canada, Mexico, and other places that have different postal address formats. I have googled about it and really didn't find anything fantastic on it. Does anyone know of a site that someone has done this and has for sale? Most of the addresses are typical but what do you do to print when not like the USA format and the zip code comes before the city? As well as other things.....? I find it hard to believe on one has all ready empowered this task and maybe one of you would know?


    Thanks

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  3. #3
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Thanks orange,
    What i am really seeking is how does one deal with instances in access with data on the forms and printing labels/Envelopes? Where such as mexico where the zip comes before the city. state? I have to assume that with this global world we live in today that someone has done this in access where the form changes when country changes, and you can print it per that country specified format? If not, I guess someone should....?

  4. #4
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    Oh, I get it. I use a that holds States\Countries and mark the International ones. Then when I concatenate the Address, City, State and Postal Code I can put in the for that Country. While this only allows for two different formats (which is all I have ever encountered to date) you could easily adapt something like to allow for several formats. Store the Address Formats in a Function and call it based on Country.

  5. #5
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    thanks GinaWhipp

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Suggestions on Mass Import of Data
    By TerraEarth in forum Import/Export Data
    Replies: 11
    Last Post: 05-02-2018, 02:33 PM
  2. Linked Data Bases for Mailing Labels
    By Kennertoy in forum Access
    Replies: 6
    Last Post: 03-20-2013, 02:26 PM
  3. The simply way to consolidate two bases...
    By jeanpri in forum Import/Export Data
    Replies: 4
    Last Post: 05-14-2012, 01:53 AM
  4. Two Data Bases Linking Tables
    By Cran29 in forum Import/Export Data
    Replies: 0
    Last Post: 05-11-2012, 01:28 AM
  5. Replies: 0
    Last Post: 05-09-2012, 02:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums