set group footer location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not able to set the specific location for my goup footer. I need the
number of lines in the detail to be able to grow but my footer is coming in
to high on the page. Can anyone help?
Shirley
 
Burt said:
I am not able to set the specific location for my goup footer. I need the
number of lines in the detail to be able to grow but my footer is coming in
to high on the page.
Click to expand...


A group footer always appears immediately after the last
detail in the group.

Maybe you could explain what you're trying to do?
 
I am printing statements with a varing amount of detail lines. I need the
group footer to print 3.5 inches up from the bottom of the page as I am using
preprinted forms. I read acticle 208979 and I created the module Set group
footer location but I don't understand how to tell it where to print. I can
make the footer larger and place my fields down in the middle of the footer
and it will print in the correct location but I can not use the room above
the fields and it eats into my detail printing area.
 
Burt said:
I am printing statements with a varing amount of detail lines. I need the
group footer to print 3.5 inches up from the bottom of the page as I am using
preprinted forms. I read acticle 208979 and I created the module Set group
footer location but I don't understand how to tell it where to print. I can
make the footer larger and place my fields down in the middle of the footer
and it will print in the correct location but I can not use the room above
the fields and it eats into my detail printing area.
Click to expand...


The 7 in the function call in the OnFormat property tells it
to print approximately 7 inches from the top of the page.
Change that to meet your needs (7.5?).

Note: that technique is not especially accurate and, if
everything isn't "just right" in your report, won't be
precise enough for preprinted forms.

There is a more precise approach, but only if you are using
A2002 or A2003.
 
What is the more precise approach? I really need to make sure it prints in
the same place each time. Thank you for all your help
 
I am using a2003.

Marshall Barton said:
The 7 in the function call in the OnFormat property tells it
to print approximately 7 inches from the top of the page.
Change that to meet your needs (7.5?).

Note: that technique is not especially accurate and, if
everything isn't "just right" in your report, won't be
precise enough for preprinted forms.

There is a more precise approach, but only if you are using
A2002 or A2003.
Click to expand...
 
Burt said:
What is the more precise approach? I really need to make sure it prints in
the same place each time. Thank you for all your help
Click to expand...


The technique I use is to adjust the Height of the last
detail section.

First, add a (hidden?) text box named txtDtlCnt to the group
header section. Set its control source expression to
=Count(*)

Second, add a (hidden?) text box named txtLine to the detail
section. Set its control source expression to =1 and its
RunningSum to Over Group.

The code in the report would be along these lines:

Private lngDetailHeight As Long

Private Sub Report_Open(Cancel As Integer)
lngDetailHeight = Me.Section(0).Height 'save original
End Sub

Private Sub Detail_Format(Cancel As Integer, FormatCount As
Integer)

If Me.txtLine = Me.txtDtlCnt Then
Me.Section(0).Height = 7.5 * 1440 - Me.Top 'expand detail
Else
Me.Section(0).Height = lngDetailHeight ' normal details
End If
End Sub


The code can get quite a bit messier if the last detail
intrudes into the space needed for the footer.
 
Back
Top