Handling International AND North Amer. Addresses?

[Shannon R.]

Hello all. I have a question regarding how to handle both
North American AND International addresses. I am making a
mailing list and I will need to print labels for all
addresses. My question is....how should I set up the
database? I now have the columns for City, Province/State,
etc. for North American addresses but when I went to enter
the Int'l ones I realized I had a problem. I am thinking
of adding one column for the int'l addresses and enter the
whole address in that field in the form rather than split
their addresses up as we do with NA ones. Will that be
possible? The ability to have multiple rows of text in one
field? Then, how do I go about doing the mailing labels
for both types of addresses? (I know HOW to do the labels)
but would it be a two setep process? Print NA and then
print Int'L?

Please, any help would be appreciated. I am a complete
newbie! THANKS!

Please reply to my email or on here. Thanks, and have a
great day!

Shannon R.

 

[Cheryl Fischer]

Shannon,

The first thing I would suggest is for you to open the sample database,
Northwind.MDB, which ships with each copy of Access. This sample db deals
with an internationalized customers list containing North American, European
and Asian addresses. If you will look at the form Customers, you will see
that each address is handled in the same way with no need to treat
international addresses any differently from the North American.

The address control on the Customers form does allow for multiple lines.
There are two ways to do this: instruct your users to use CTRL-Enter to
insert a new line in the control, or in design view of the form set the
control's Enter Key Behavior from its default value to 'New Line in Field',
which will allow the user to simply press Enter for a new line. If you do
that, however, your users must use the tab key to move out of the field.

There is no label report sample in the Northwind database, but I used the
Label Wizard to create labels using the Avery 5162 option. It appeared to
set up just fine. One thing you will need to do when you design your label
report is to set the Can Grow and Can Shrink properties of each control on
the report to 'Yes'.

hth,