MS Access Reports

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

Guest

How do you highlight the first record in the detail section of a report. The
report has multiple groups, and field footers. I would like to be able to
show a text box on the first detail record only, of each group.
 
GamecocksBaseball said:
How do you highlight the first record in the detail section of a report. The
report has multiple groups, and field footers. I would like to be able to
show a text box on the first detail record only, of each group.
Click to expand...


Add a text box named txtLine to the detail section. Set its
ControlSource to =1 and RunningSum to Over Group. This
allows you to check which detail is being processed so you
can use a line of code in the detail section's Format event
to make the text box visible or not as desired:

Me.yourtextbox.Visible = (Me.txtLine = 1)
 
Back
Top