Wayne, thank you for your effort, but you are like someone I used to work
with that if you asked the time he would tell you how to make a clock. I
think you're over thinking this. My Access database I have columns for 1st
name, last name, street address, city, state, zip, country, phone, email and
more. You can click on the "Create" tab at the top, in the "reports" section
you select "Labels". You can there select the Avery label you are using. In
my case "5160" (a 1" x 2 5/8" label). Click next and select your font and
size, text color. Click next and there is a window showing all available
fields. It list all your columns, except for some reason it doesn't list
"Street Address". So I can easily select the names, city, state, zip. but I
can't get the street address. Seems like a very easy process. Once the fields
are selected, click next and select what order you want your labels to sort
by ie: Last Name, or something else. Click next, name the file then click
Finish. At that point it gives you a view of the label file you created. In
my case 5 pages, 3 labels wide, 10 labels tall.
Would anyone know why my "street address" column would not show up in this
list of "Available Fields"?
Sorry for the length of this but I think I may have been misunderstood
