Report vba scripting
Hello, I cant figure this one out:
I have a textbox with control source [APPLICATION], when I run/execute the report, depending on the persons name and etc etc, the application will display either: house, hospital, or car.
At the same time I have 2 labels: Label1 and Label2. Nothing is bound btw.
What do I do if I want to hide Label1 (visible=false) but display Label2, if the result of the textbox with source [APPLICATION] is "house". and hide Label2 and display Label1, if the result of the textboxt with source [APPLICATION] is "hospital"
Can someone please code this for me?