Forum Discussion

Copper Contributor

Dec 23, 2022

Access - mailing labels

I was trying to accomplish a fairly simple task, one that I used to do frequently in Access but it has been several years (and versions) since I did this. I tried creating some mailing labels using "...

access

Bruceakabatman

Copper Contributor

Dec 24, 2022

George_Hepworth I appreciate your response. Why would I need to do anything with the margin when I selected a standard label from Avery. I don't recall having to make margin adjustments in the past. Where do I go to make the adjustments? As for the second error, again it is the way i always did them in the past. How do I show you the criteria?

George_Hepworth

Silver Contributor

Dec 24, 2022

Bruceakabatman

We really can't just count on printers and reports, including the labels, to be universally the same; sometimes adjustments are needed.

Here's where you can find the Page Setup options:

Here's how to copy the SQL.

I made a screenshot for illustration, but it's better to copy and paste the actual SQL.

Thanks for the kind words.

Bruceakabatman
Copper Contributor
Dec 24, 2022
George_Hepworth I appreciate you trying to assist me. I am in deep trouble with my wife. My only job was to print the labels for the Christmas letter and thus far, I have failed miserably. Anyhow, I can't seem to match up your screen shots with my system. I must have a different version.
- Bruceakabatman
  Copper Contributor
  Dec 24, 2022
  I don't know where you are finding the Page Setup. (I'm obviously a real novice with this.)
  - George_Hepworth
    Silver Contributor
    Dec 24, 2022
    Bruceakabatman
    
    First open the report in Design View.
    
    The ribbon will update to show the related tabs, including Print Setup.
    
    Your screenshot shows an empty query, not the report's recordsource. Use the three little dots at the right end of the recordsource property to open that SQL.