Show or Hide different controls for each record in preview

_JSincliar

Registered User.
Local time
Today, 11:37
Joined
Dec 9, 2009
Messages
16
I have a report with a series of controls, whose visibility and position change depending on the record. When I preview the report before printing, it formats which controls are visible for the first record only, and all other records follow that template even if they need to show something different.
Is there a way I can re-run that section of code so they are each formatted individually?
I tried the OnCurrent event, but I'm not sure if that exactly what I'm after. I haven't even been able to test it as when I move the VBA into the OnCurrent sub, the code never even runs.

Thanks in advance!
 
It should go in the On Format event for the section the controls are in.
 
That seems to have done the trick!
Thank you very much.
 

Users who are viewing this thread

Back
Top Bottom