Mixing Different Address Formats In Access 2007

[mrdee 1]

I would like to set up an address database in Access 2007.

This is normally a fairly straightforward job, however, things are never that black and white with me.

The problem is, I need to add addresses from different countries (UK, Australia and Belgium), and they use slightly different formats.

For example, in UK and Australian addresses, you write the house number first and then the street name, eg. 123 Somestreet, while, in addresses from Belgium, you do the opposite, the address there looks like Somestreet 123.

There is also a difference in how the post codes are formatted:

In the UK, the post code is made up of letters and numbers (eg. SL3 8BY) and this is written after the town name and county name, eg. Slough, Berks, SL3 8BY.

In Australia, the post code is a four digit number (eg. 3190), written after the town name, eg. Frankston, 3190, Victoria.

In Belgium, the post code is also a four digit number, but it is written in front of the town name, eg. 8400 Oostende.

My question is now, how can I set up the database so the addresses display, and especially (that is my main concern) print out correctly on envelopes, so that all addresses in the different countries come out right, something like:

UK:

Mr. Smith

12 Station Road

Slough

Berks

SL3 8BY

Australia:

Mr. Jones

198 Kangaroo Street

Frankston 3190

Victoria

Belgium:

Mr. Janssens

Prutsstraat 124

8400 Oostende

If anyone can point me into the right direction, I would be very grateful for any relevant advice.

Edited December 9, 2011 by mrdee (see edit history)