Forum Discussion
Access - mailing labels
Page margins refers to the blank spaces around the edge of a page. The width of that blank space, or margin, is set in the report properties. I assume you are trying to print to a standard 8.5 x 11 inch page of labels, or the equivalent A4 size page, which is 210 x 297 mm, or 8.268 x 11.693 inches.
The width of the page, minus the width of the left margin and the width of the right margin, is the space available for printing your labels. With labels, there can also be a small space between them on the page, so depending on the number of columns, you have to account for that as well.
In short, you need to adjust the margins specified for your labels report to fit the width of the page, less the width of the labels (2 or 3 depending on which layout you have) less the various margins.
The second problem regarding the parameter value is probably due to a criteria in the query which returns the records to be printed on the labels. It could be a problem with inaccurate syntax or it could be a reference to a control on a form. Therefore, we'd have to see that query, or more exactly, the SQL in that query, to know how to advise on that.
Trim is used to remove leading and trailing spaces in text strings. That's important in labels which tend to have restricted amount of room for printing.
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?
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.
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.
- I don't know where you are finding the Page Setup. (I'm obviously a real novice with this.)
- BTW - I'm definitely going to take your on-line course. I was excited to find it. So much has changed in Access since I used it last, it is like I am using a brand new program.
