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

Report Page Header - Can Grow?

P: n/a
Hi,

I am using Access 2003.

I have set up an invoice in a report. I have set up the name and
address as text boxes in the Page Header which I've made as small as
possible then set the Can Grow property to Yes. This works fine.

Below that, there is the column headers for the sales lines which
appear in the Detail section.

The problem I am having is that there doesn't seem to be the ability
to have Can Grow in the Page Header. This means that I have to guess
how tall to make the Page Header so that the name and address can grow
into it. Unfortunately, with some addresses, this means that there is
a large gap between the column headers and the sales lines in the
Detail section. If I reduce the size of the Page Header, sometimes
the column headers are cut off, as the name and address have grown to
the point where they take up most of the Page Header section.

I have seen that the Report Header has a Can Grow property, but that
would then mean that if the invoice went over one page, that the
Company Name and details would only print on the first page, and I
need that on each page, as, essentially, the Page Header.

Is there a way around this?

Many thanks,

Franc.
Sep 16 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Create a group header on the InvoiceID.
Set the Repeat Section property of this section to Yes.
It will repeat on any subsequent pages.

--
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.

"franc sutherland" <fr**************@googlemail.comwrote in message
news:ce**********************************@e39g2000 hsf.googlegroups.com...
>
I am using Access 2003.

I have set up an invoice in a report. I have set up the name and
address as text boxes in the Page Header which I've made as small as
possible then set the Can Grow property to Yes. This works fine.

Below that, there is the column headers for the sales lines which
appear in the Detail section.

The problem I am having is that there doesn't seem to be the ability
to have Can Grow in the Page Header. This means that I have to guess
how tall to make the Page Header so that the name and address can grow
into it. Unfortunately, with some addresses, this means that there is
a large gap between the column headers and the sales lines in the
Detail section. If I reduce the size of the Page Header, sometimes
the column headers are cut off, as the name and address have grown to
the point where they take up most of the Page Header section.

I have seen that the Report Header has a Can Grow property, but that
would then mean that if the invoice went over one page, that the
Company Name and details would only print on the first page, and I
need that on each page, as, essentially, the Page Header.
Sep 16 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.