Hi All;

I have a pallet report that shows the number of rolls, number of impressions and weight for each roll along with two bar codes. This is actually a shipping label and needs to be on one page. I set the detail section for multiple columns and also set the column width and distance between lines and all was well. Unfortunately, I have to total the impressions and weight and that is causing the group footer to force a second page on pallets with higher quantities of rolls. Bearing in mind that I am a VBA novice, is there ANY way that anyone knows of to force this onto one page? Not sure how to attach the report, or I would have!

Thanks in advance for any help or suggestions!

Pete