Newbie Report Question: Hide fields for a specific group heading

[Derick1229]

I have a question that is currently driving me crazy:

I created a report from a query and have a Group Header for the field called 'txtHeaders'. When this field equals "Interfaces" then I need hide/unhide several fields in the Detail section. I would think that this would be fairly simple but for whatever reason my approaches are not working. How would I go about doing this in vba?

 

[dhookom]

Add code to the On Format event of the Detail Section.

  Me.txtA.Visible = (Me.txtHeaders = "Interfaces")

This assumes txtHeaders is a bound text box in the report.


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]

 

[Derick1229]

That worked. Thank you very much for your help!