Xtra pages in report

C

Carla

Hi
I'm creating a report. I have a number of query and
calculated fields in the report. The report should only
be 1 page long, but for some reason there are 11 (the
number of calculated fields). How can I remedy this? Any
ideas? Thanks
Carla
 
N

Nikos Yannacopoulos

Carla,

Open your report in design view, select the section where the calculated
fields are in (detail?, group header or footer?) by clicking on the grey bar
just above it that reads Detail or [ControlName] Header or [ControlName]
Footer, and check the setting of the Force New Page property on the Format
tab; chances are it is set to Before Section or After Section or Before and
After, whereas it should be set to None so as not to force new pages.

HTH,
Nikos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
Access MSACCESS - Sorting report based on field calculated in the report 0
Access MS Access - Reports - Limit records to print. 0
report parameter 2
Group last line of details and report footer 0
Can't create a report from my query in Access 1
Export to XML - error 31532 0
Access How to prevent subReport from breaking across pages? 1

Top