Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formatting the Report to fit Multiple Items

Status
Not open for further replies.

infinitx

Technical User
Feb 26, 2004
212
US
Hi,
I am developing a databse program that will store test questions.

When a person enters a test question (Multiple Choice), it is added to an Item Table.

After the person has entered all of his questions, he wants to select only a few to appear on the actual report.

My question is, when I make a report, it always puts only one question per page. If I have two questions, it has one question on one page and another question on another page. I was wondering, how can I get both of the questions to appear on the same page?

Thanks in advance!
 
Try letting the Access wizard automatically generate a report of the test questions and find out if the result does the same thing. If not, start comparing the properties from the one report to the other report and see what is different.
That said, here are a few ideas, but I'm just shooting in the dark...
-If the test question has a sufficient number of characters and "CAN GROW" is Yes, it may spill to the next page.
-Formatting has choices for page breaks. If it is set to break after each group, and a test question is a group, you'll get a page break. Also check setting in sorting and grouping.
-If your test question text box is in the page header or page footer of the report, you will get one per page.

---------------------------------------
The customer may not always be right, but the customer is always the customer.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top