Report 1 record per page

AccessWimp

New member
Local time
Today, 11:09
Joined
May 11, 2005
Messages
7
Hi - Trying to use report instead of Word Mail Merge. Have an 8 1/2 by 11 form that needs to get filled out by results of query. No problem with this except I get 1 record on a page, then a blank page, and then another record. How can I get rid of the blank page. I have no lines in the report, and no sections that could be over-sized causing a second page. Any thoughts would be appreciated.
 
Ok, problem solved. Even though all controls on the right side of the report were right alligned at the right margin, one pesky textbox was apparently taking up unseen real estate in the margin causing the 2nd page to show. Moving each control slightly to the left one at a time helped me find the offender. Once I found which control was causing the problem I moved it back to what looks like the exact same spot and now every thing is fine. Weird.
 

Users who are viewing this thread

Back
Top Bottom