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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Gouping In Sub Reports Leaving Windowed Headings 2
Group last line of details and report footer 0
Printing of sub-report skips to second page. 3
page header on second page of invoice. 3
How to count records using count(*) in a chart report 3
A03 - count in report footer gives me #Error? 0
Grouping problem with labels report form 6
Control detail section height size in Ac2007 2

Back
Top