Message when printing labels

T

ToniMaura

Win XP - Access 2003

When I print labels sometimes is not possible adjust the space-columns..
and access displays a message warning telling that there is not space in the
page.... but the label prints ok.

I tried to capture and disable the message via report_error event and others
and could not do it.
Anybody knows the error number or other way to disable this message warning.
Thanks
 
A

Allen Browne

It is possible to adjust the sizes.

In report design, choose Page Setup from the File menu.

Subtract the Left and Right margins from the Page Width.
Subtract the space between columns times the number of spaces between
columns.
Divide what's left by the number of columns.
Make sure the Width of the report no more than than that.

You can work similarly with the Page Height, Top and Bottom Margins, spaces
between rows, and Height of the Detail section.
 
Top