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

Labels In Pageheader Of Report

P: n/a
I created a report that has labels in the top three inches of the page
header. There's also an unbound subform there. When I go to preview or
print, the records from the detail section overlap about the bottom two
inches of the labels so they can not be seen. Does anyone have any ideas as
to what causes this?

Thanks!

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


P: n/a
Access cannot dynamically resize the Page Header or Page Footer sections.

Instead, use a Group Header, and set its Repeat property to Yes so it
appears at the top of each page. You can set the Group Header's CanGrow
property to Yes so it resizes to handle as much space as the subreport
needs.

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

"Melissa" <mb****@earthlink.net> wrote in message
news:Yv******************@newsread3.news.atl.earth link.net...
I created a report that has labels in the top three inches of the page
header. There's also an unbound subform there. When I go to preview or
print, the records from the detail section overlap about the bottom two
inches of the labels so they can not be seen. Does anyone have any ideas
as
to what causes this?

Nov 13 '05 #2

P: n/a
Allen,

Thanks for the quick response!

Is there a way to get a reportheader to repeat on each page? My subform is
in the middle of the labels.

Melissa
"Melissa" <mb****@earthlink.net> wrote in message
news:Yv******************@newsread3.news.atl.earth link.net...
I created a report that has labels in the top three inches of the page
header. There's also an unbound subform there. When I go to preview or
print, the records from the detail section overlap about the bottom two
inches of the labels so they can not be seen. Does anyone have any ideas as to what causes this?

Thanks!

Melissa

Nov 13 '05 #3

P: n/a
No. The Report Header section cannot repeat.

Use a group header.

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

"Melissa" <mb****@earthlink.net> wrote in message
news:vd******************@newsread3.news.atl.earth link.net...
Allen,

Thanks for the quick response!

Is there a way to get a reportheader to repeat on each page? My subform is
in the middle of the labels.

Melissa
"Melissa" <mb****@earthlink.net> wrote in message
news:Yv******************@newsread3.news.atl.earth link.net...
I created a report that has labels in the top three inches of the page
header. There's also an unbound subform there. When I go to preview or
print, the records from the detail section overlap about the bottom two
inches of the labels so they can not be seen. Does anyone have any ideas

as
to what causes this?

Thanks!

Melissa

Nov 13 '05 #4

P: n/a
Thanks again, Allen!

How do I create a group header that is not bound to one of the fields in the
recordsource? I recall that somewhere you put = True and I don't recall if
it's in the query which is the record source and if you need a textbox
somewhere. I have been looking through my notes but can't find my notes on
how to do it.

Melissa
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
No. The Report Header section cannot repeat.

Use a group header.

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

"Melissa" <mb****@earthlink.net> wrote in message
news:vd******************@newsread3.news.atl.earth link.net...
Allen,

Thanks for the quick response!

Is there a way to get a reportheader to repeat on each page? My subform is in the middle of the labels.

Melissa
"Melissa" <mb****@earthlink.net> wrote in message
news:Yv******************@newsread3.news.atl.earth link.net...
I created a report that has labels in the top three inches of the page
header. There's also an unbound subform there. When I go to preview or
print, the records from the detail section overlap about the bottom two
inches of the labels so they can not be seen. Does anyone have any
ideas as
to what causes this?

Thanks!

Melissa


Nov 13 '05 #5

P: n/a
Yes, you could simply type:
True
into the Field row in query design, and group on that.

Or you could type:
[ID] = [ID]
into the Sorting'n'Grouping box, where ID represents the name of your
primary key field.
--
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.
"Melissa" <mb****@earthlink.net> wrote in message
news:N5******************@newsread3.news.atl.earth link.net...
Thanks again, Allen!

How do I create a group header that is not bound to one of the fields in
the
recordsource? I recall that somewhere you put = True and I don't recall
if
it's in the query which is the record source and if you need a textbox
somewhere. I have been looking through my notes but can't find my notes on
how to do it.

Melissa
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
No. The Report Header section cannot repeat.

Use a group header.

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

"Melissa" <mb****@earthlink.net> wrote in message
news:vd******************@newsread3.news.atl.earth link.net...
> Allen,
>
> Thanks for the quick response!
>
> Is there a way to get a reportheader to repeat on each page? My subform is > in the middle of the labels.
>
> Melissa
>
>
> "Melissa" <mb****@earthlink.net> wrote in message
> news:Yv******************@newsread3.news.atl.earth link.net...
>> I created a report that has labels in the top three inches of the page
>> header. There's also an unbound subform there. When I go to preview or
>> print, the records from the detail section overlap about the bottom
>> two
>> inches of the labels so they can not be seen. Does anyone have any ideas > as
>> to what causes this?
>>
>> Thanks!
>>
>> Melissa



Nov 13 '05 #6

P: n/a
Got it!

Thanks for all your help, Allen!

Melissa
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
Yes, you could simply type:
True
into the Field row in query design, and group on that.

Or you could type:
[ID] = [ID]
into the Sorting'n'Grouping box, where ID represents the name of your
primary key field.
--
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.
"Melissa" <mb****@earthlink.net> wrote in message
news:N5******************@newsread3.news.atl.earth link.net...
Thanks again, Allen!

How do I create a group header that is not bound to one of the fields in
the
recordsource? I recall that somewhere you put = True and I don't recall
if
it's in the query which is the record source and if you need a textbox
somewhere. I have been looking through my notes but can't find my notes on how to do it.

Melissa
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41***********************@per-qv1-newsreader-01.iinet.net.au...
No. The Report Header section cannot repeat.

Use a group header.

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

"Melissa" <mb****@earthlink.net> wrote in message
news:vd******************@newsread3.news.atl.earth link.net...
> Allen,
>
> Thanks for the quick response!
>
> Is there a way to get a reportheader to repeat on each page? My subform
is
> in the middle of the labels.
>
> Melissa
>
>
> "Melissa" <mb****@earthlink.net> wrote in message
> news:Yv******************@newsread3.news.atl.earth link.net...
>> I created a report that has labels in the top three inches of the

page >> header. There's also an unbound subform there. When I go to preview or >> print, the records from the detail section overlap about the bottom
>> two
>> inches of the labels so they can not be seen. Does anyone have any

ideas
> as
>> to what causes this?
>>
>> Thanks!
>>
>> Melissa



Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.