Center Text Between Start and End of a Group

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

Guest

I have a report which I want to center the Group Text Box vertically from the
start of the group to the end of the group. Does anyone know if this is
possible??

For example if my group is called #1, and is composed of 3 lines on the
report, I want to print the group #1 like on line 2 because it in the center
of the 3 lines. I will also print this on the very left hand side.

Any suggestions???

Worst case, I have to use VBA code and count the number of items in the
group and control it that way.


Thank you,

Gary
 
Gary said:
I have a report which I want to center the Group Text Box vertically from the
start of the group to the end of the group. Does anyone know if this is
possible??

For example if my group is called #1, and is composed of 3 lines on the
report, I want to print the group #1 like on line 2 because it in the center
of the 3 lines. I will also print this on the very left hand side.
Click to expand...


Use a hidden groupt header text box named txtGrpCnt with the
expression =Count(*) to determine how many details are in
the group.

Add a text box named txtLineNo to the detail section. Set
its expression to =1 and RunningSum property to Over Group.
This allows you to determine which detail is being
processed.

Finally, add a line of code to the detail section to hide or
display the group text box:

Me.txtGroup.Visible = (txtLineNo = Fix(txtGrpCnt / 2))
 
Back
Top