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.
Allen Browne 13 December 2004 10:11:43 [ permanent link ]
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" <ozross@hotmail.com> wrote in message news:41bd3d45$1@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.>
Ross Hamilton 14 December 2004 06:30:00 [ permanent link ]
Thankyou Allen, worked like a charm.
Ross
"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message news:41bd40b6$0$29947$5a62ac22@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" <ozross@hotmail.com> wrote in message> news:41bd3d45$1@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.> >
If you would like to report an abuse of our service, such as a spam message, please . Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .
