Access - Report Detail length

A

a.neklanova

Dear everybody,
I need a help, because the lenght of report - part detail is define
max probably 55 cm and I need for my form twice, can I change it
somewhere.
Thanks
Anna
 
A

Allen Browne

Any section in a report is limited to about 22" maximmum height. If you need
more, the trick is to add more sections.

For example, if you have a report based on a table of clients, with a
ClientID primary key, open the Sorting And Grouping pane (View menu). Choose
the ClientID field, and in the lower pane of the dialog set Yes for Group
Header and for Group Footer. Access adds 2 more sections to the report - the
ClientID Group Header, and the ClientID Group Footer. Each of these can be
22" tall too. Since the ClientID value changes for every record (it is the
primary key), these 3 sections (group header, detail, and group footer)
print for every record. So you now have 66" of height for every record.

If you need more than that, add the ClientID field again on another row of
the Sorting'n'Grouping pane, so you get more header and footer sections.
 

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

Top