Forum Discussion
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 "Create", "Labels". The first error message is "There is not enough horizontal space on the page for the number of columns and columns spacing. (I had first and last name on line 1, address on line 2 and city, state and zip on line 3 - Avery labels 5260) Next error message was "enter Parameter value" and below it it said Trim. No idea what this means.
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?
- 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.
