Reports on format events

[Chance1234]

Got a report with about 10 columns, depending on what the value is in one of the headings, determines which columns i need to display.

has anyone got any good code examples of doing something similiar ?




Chance,

Filmmaker, gentleman and up for parole shortly

http://WWW.5YLAC.S5.COM

,

http://WWW.HOWTOBESPOOKY.CO.UK

 

[dhookom]

You can use code in the On Format event of a section to set controls to visible or not. I have no idea what you mean by "value is in one of the headings".

To get a more specific answer, I think you need to ask a more detailed question.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Chance1234]

In one of the headers i have a field called
bob for arguments sake.

If bob = "Green"

then i want the fields "One", "Two" visisble in the detail section

If bob = "Red"

then i want the fields "Two", "three" Visible in the detail section

Chance,

Filmmaker, gentleman and up for parole shortly

http://WWW.5YLAC.S5.COM

,

http://WWW.HOWTOBESPOOKY.CO.UK