(Msg. 1) Posted: Wed Jul 16, 2008 7:59 am
Post subject: With two columns of data, how to make header appear at top of both Archived from groups: microsoft>public>access>reports (more info?)
Hello,
MS Access 2003 XP Pro.
I have found out how to get my data to appear in two columns on a report but
as of right now, my header only appears over the first column. How can I get
the column over both columns?
Thank you
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!
(Msg. 2) Posted: Wed Jul 16, 2008 11:08 pm
Post subject: Re: With two columns of data, how to make header appear at top of both [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Presumably you found the Page Setup dialog (on the File menu), and on the
Columns tab set up multiple columns?
On that tab, uncheck the box for "Same as Detail section."
Now you can widen the report width without changing the column width. You
can now repeat the label in the Page Header section, and place it so it
turns up over the righthand column.
(The Page Header is independent of the columns, i.e. it is printed across
the top of the page.)
--
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.
"BlueWolverine" <BlueWolverine DeleteThis @discussions.microsoft.com> wrote in message
news:8BC41DF9-80D1-4006-94A5-A002CA3E7DF4@microsoft.com...
> Hello,
> MS Access 2003 XP Pro.
>
> I have found out how to get my data to appear in two columns on a report
> but
> as of right now, my header only appears over the first column. How can I
> get
> the column over both columns?
> Thank you
> --
> BlueWolverine
> MSE - Mech. Eng.
> Go BLUE!
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum