Need to suppress an error message

[Cynthia]

I have a Report to print labels.

I have it open from a Macro in 'print preview' so that the number of pages of labels can be seen before a print run is started. Unfortunately, my first data line is this

=Trim([Title] & " " & [First first name] & " " & [First surname] & " " & [Spouse/family] & " " & [Second first name] & " " & [Second surname])

I believe it will work OK because there is only data in either the [Spouse/family] field or [Second first name] & " " & [Second surname]

(These fields are inherited from a previous database. I may be able to lose them later)

Anyway, my problem is that I get an error message that there is not enough horizontal space on the page. Can I suppress that error message and if so, How?

 

[Cynthia]

I have now overcome the problem by narrowing the page size in the report.

I have to say that I have never had any success with anything using a wizard. I used it in this instance because it would appear to save a lot of trial and error for a known make and size of labels.

I also found that the bottom 2 labels were not being printed. That was solved by reducing the bottom margin set by the wizard. I also increased the left margin by 5mm and the font size from 8 to 10..

That all looks much better and works!