Open Report and Hide Control using VBA

[tylerg11]

I am using the following syntax to open my report:

DoCmd.OpenReport "[Report]", acViewPreview

But I also want to be able to hide a control on that report using VBA. I am using the following syntax and it isn't working for me. Any ideas?

Reports![ReportName]![SubReportName]![ControlName].Visible = False

[RuralGuy]

You might try:
Reports![ReportName]![SubReportName].REPORT.[ControlName].Visible = False

[tylerg11]

Still doesn't work. An error pops up that says, "Run-time error '2455': You entered an expression that has an invalid reference to the property Form/Report."

I wonder if you can't hide a control with code??

[tylerg11]

Oh, I figured it out. Dumb mistake. I am opening the report in PrintPreview so I obviously can't hide a control at that point. It works in Report View. I wonder if I can open it in Report View, hide the control, and then display in Print Preview

[RuralGuy]

I'll bet you will figure it out.