Runtime error 2465 although a field in report's record source defined

[jaworski_m]

Hello,

I would like to hide/display some fields on a report when it is open basing on the value in [currencyName] field. The field is already defined in the report's record source. The definition is OK as the field is displayed correctly on the report when no VBA is run.
The field is located in report's heading.



Once the code is run I get the following error: "Runtime error 2465 report can't find the field currencyName" which is triggered by the first line of the IF statament.

    
If Me.currencyName = "EUR" Then
 ' do something
 End If

I tried to put the code in different locations (report event, heading event) and also tried referencing the field using "Report!...." syntax but still get the same error

I do not know why the error is displayed and how to fix it.
Thank you for any hints.

[June7]

This would be setting Visible property of controls. Code must be in the OnFormat event of the section the controls are in. OnFormat event triggers only when direct to print or Print Preview, not Report View.

Even though controls are not visible, they still occupy space.

What controls do you want to hide and why?

[jaworski_m]

Code must be in the OnFormat event of the section the controls are in. OnFormat event triggers only when direct to print or Print Preview, not Report View.

This worked.
Thank you.


Additionally, I made a simple mistake in my way of thinking while writing VBA.
I was referefing to field's source, yet I had to refer to field's name, which was different.