ACCESS FEED: RE: [MS_AccessPros] Report header with three column report

Selasa, 10 Juni 2014

RE: [MS_AccessPros] Report header with three column report

Douane,

Extensive 'fiddling' with the sizes has let me have three columns under a full page header.

It is not very intuitive is it?

Thanks for your help.

Robin Chapple

At 10/06/2014 04:43 PM, you wrote:

Column width is one third of the page width.

At 10/06/2014 12:11 PM, you wrote:

Did you go into the column specification and change the column width to not match the report width?

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 10 Jun 2014 09:41:15 +1000
Subject: RE: [MS_AccessPros] Report header with three column report

Duane,

I believe that is what I did. I have shown some graphics here necause it is hard to explain:

http://www.rotary9790.org.au/test/test.asp

Cheers,

Robin Chapple

At 10/06/2014 07:53 AM, you wrote:
\

I believe the report width can be full page width allowing you to copy the headers multiple times:

Full Name Department Phone Full Name Department Phone Full Name Department Phone
========== ============ ======= ========== ============ ======= ========== ============ =======

Make sure your column width property is set to only a single column width. You need to play with this a bit.

Duane Hookom MVP
MS Access

> To: MS_Access_Professionals@yahoogroups.com
> From: MS_A ccess_Professionals@yahoogroups.com
> Date: Tue, 10 Jun 2014 06:44:54 +1000
> Subject: [MS_AccessPros] Report header with three column report
>
> I have a three column report and need the report header to span the
> three columns.
>
> How do I achieve that?
>
> Many thanks,
>
> Robin Chapple