Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show 1st Group0_Header but hide the rest 1

Status
Not open for further replies.

franksirvent

Programmer
Mar 8, 2002
358
0
0
GB
Hi

I have a report which I would like to show the data/fields on the Group0Header section but only from the first record...after that, I need the Group0Header to become invisible.

Could anyone help?

thanks in advance
 
You can try add a text box to the section:
Name: txtCountHeader
Control Source: =1
Running Sum: Over All
Then add code to the On Format event of the section:
Code:
  Cancel = Me.txtCountHeader >1

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
THANKS MATE !!!!

great ! it works great !!!

exactly what I was looking for !!!
thank you again !!!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top