Forum home » Delegate support and help forum » Microsoft Access Training and help » Acces Report Layout

Acces Report Layout

ResolvedVersion 2003

Fri 16 Oct 2009, 16:19 Delegate Claire said...

Claire has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Access Intermediate course

Acces Report Layout

We were shown how to put each new set of data on a new sheet, however where data sets were small this would mean wasting paper if the data only took up half a page. Is there a way to only go to a new sheet if two lots of data won't fit on one?

Tue 20 Oct 2009, 08:56 Trainer Stephen said...

RE: Acces Report Layout

Hi Claire

Thank you for your question

The best solution here is to not place a page break in each group footer. This will avoid the waste of unnecessary space.

To prevent groups spreading over more than one page you can select the keep together option in the group menu

Hope this helps, if you need any further help, please do not hesitate to contact me

Regards

Stephen

Mon 26 Oct 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

Acces Report Layout

Acces Report Layout

RE: Acces Report Layout

Access articles

Access tip:

Hiding Multiple Table columns