Print full page of labels

[mohebk]

Hi,
I have a simple labels report that prints only one column of labels. Is there a setting that i need to change to allow it to print a full page with 3 labels in each raw?
Thanks

Mo

 

[Eupher]

One way is to set columns in the report's Page Setup (File->Page Setup on the menu).

Ken S.

 

[mohebk]

Thanks a bunch. That did the trick. One more question though. How can I have the lables repeat and print one page per record?
Thanks in advance.

Mo

 

[Eupher]

There's probably a better way, but the method that comes to mind is to create a one-field table and put data in the single field to create the same number of records as there are labels per page (the actual data doesn't matter, it will not appear anywhere in your report). So if your labels are 30 per page, put 30 records in your little table. Then include that table in the query that is the basis for your report (or create a new query that uses your original query and this table). That will force the query to generate 30 instances of each label - voila! - one page per record.

HTH,

Ken S.

 

[Eupher]

Here's a FAQ that maybe explains it better than I did:

faq703-3276

HTH,

Ken S.

 

[mohebk]

Thanks, I will try that.

Mo