By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,678 Members | 1,904 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,678 IT Pros & Developers. It's quick & easy.

Page header does not display when using Columns

P: n/a
Can anyone help me with this small problem.

I have a report that is divided into 3 Columns using the page setup, It
displays the report fields in 3 separate columns (Desc & Pg Num) but it only
displays the Page Header on the first column.

Any thoughts??
regards,

Ross

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
The page header relates to the page, not the columns.

If you want the headings repeated over the subsequent snaking columns also:
1. Go to File | Page Setup | Columns, and uncheck the box "Same As Detail".
Access will then keep the detail section to the width specified in that
dialog, regardless of how wide the report itself is. While you are there,
note down the Width and the Column Spacing values. Close the dialog.

2. Back on the report, make it as wide as appropriate. For example, if you
have 11" x 8.5" paper with left and right margins of 1", make it 6.5" wide.

3. In the Page header section, repeat the labels to the right. You can line
them up based on the Column Width + Column Spacing. The repeat them again
for the 3rd column.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ross Hamilton" <oz****@hotmail.com> wrote in message
news:41********@news.highway1.com.au...
Can anyone help me with this small problem.

I have a report that is divided into 3 Columns using the page setup, It
displays the report fields in 3 separate columns (Desc & Pg Num) but it
only
displays the Page Header on the first column.

Any thoughts??
regards,

Ross

Nov 13 '05 #2

P: n/a
Thankyou Allen, worked like a charm.

Ross

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
The page header relates to the page, not the columns.

If you want the headings repeated over the subsequent snaking columns also: 1. Go to File | Page Setup | Columns, and uncheck the box "Same As Detail". Access will then keep the detail section to the width specified in that
dialog, regardless of how wide the report itself is. While you are there,
note down the Width and the Column Spacing values. Close the dialog.

2. Back on the report, make it as wide as appropriate. For example, if you
have 11" x 8.5" paper with left and right margins of 1", make it 6.5" wide.
3. In the Page header section, repeat the labels to the right. You can line them up based on the Column Width + Column Spacing. The repeat them again
for the 3rd column.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ross Hamilton" <oz****@hotmail.com> wrote in message
news:41********@news.highway1.com.au...
Can anyone help me with this small problem.

I have a report that is divided into 3 Columns using the page setup, It
displays the report fields in 3 separate columns (Desc & Pg Num) but it
only
displays the Page Header on the first column.

Any thoughts??
regards,

Ross


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.