Printing a Text Cell in the center of a Grouping

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

Guest

Is there something that can help me print a text box on the left side which
is in the center (within 1 record) of a format grouping??

I could print the first text box only for a group. That easy, just select
the Hide Duplicates. This will print that text box only that the beginning
of each grouping.

Is there a method to allow me to print that text box in the center of the
grouping within 1 record or line?????

Do I have to count the number items in the group ahead of time and take the
integer part of the count divided by two and activate the text box there???

Any suggestion is deeply appreciated !!

Thank You,

Gary
 
Gary said:
Is there something that can help me print a text box on the left side which
is in the center (within 1 record) of a format grouping??

I could print the first text box only for a group. That easy, just select
the Hide Duplicates. This will print that text box only that the beginning
of each grouping.

Is there a method to allow me to print that text box in the center of the
grouping within 1 record or line?????

Do I have to count the number items in the group ahead of time and take the
integer part of the count divided by two and activate the text box there???
Click to expand...


No method for that. Use an text box named txtGrpCnt in the
group header section with the expression =Count(*) to
determine the record countfor the group.

To figure out which line you are processing, add a text box
to the detail section. Name it txtLineNum, set its control
source expression to =1 and its RunningSum property to Over
Group.

Then the code in the detail section's Format event would be
like:

Me.tehtextbox.Visible = (txtLineNum = CInt(txtGrpCnt / 2))
 
Back
Top