Labels In Pageheader Of Report

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

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

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
 
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
 
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.
 
Got it!

Thanks for all your help, Allen!

Melissa


Allen Browne said:
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.

Reply to group, rather than allenbrowne at mvps dot org.
Melissa said:
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


subform
is
Click to expand...
Click to expand...
 
Back
Top