Need full state name from abbreviation

[Rennie]

Hi all, 

 

I am printing a directory from a membership list. No problem getting it laid out, sorted and grouped by country, state and last name but I want it to print like this:

 

Country

    State

       Member  1 data

 

       Member 2  data

 

       etc….

 

and the problem I have is that the state field uses state abbreviations not full state names. I am trying to come up with a way to have the full state name display in the printed directory but still have the abbreviations in the address block of the data entry layout.

 

Appreciate any creative ideas, 

 

Thanks!

 

[comment]

Why don't you create a table of States with two fields (full name and abbreviation) and relate it to your Members table matching on the abbreviation. Then place the full name field from the States table in the sub-summary by State part of your layout.

[LaRetta]

Comment's method will be much more efficient than a Case() calculation with the added ability to include zips (and pre-fill during data-entry) or adding foreign countries and zips as needed.

 

It seems that most all solutions which include addresses utilise an address database or they use web viewer or various techniques such as Ziptastic http://www.excelisys.com/blog/2013/03/15/ziptastic-accessinga-web-service-from-filemaker-pro-12-to-retrieve-city-state-country-with-zip/ by http://www.excelisys.com

[Rennie]

Thanks comment, that is simple and works perfectly!