If Statement Condition - Opening Report

[geraldk]

Hello,



I have a report that getting it's data from a query, and I would like to check for a value in a text field that is being populatated and if it meets condition for if statement then make another field visible.

I can do this in a form

if me.txtField.value =1 then
me.txtField1.visible = true
else
me.txtField1.visible - false
endif

Can this be done?

Thank you in advance.

[pbaldy]

Yes; you'd do it in the format event of the section containing the textbox (typically the detail section).

[geraldk]

Perfect. Thanks!

[pbaldy]

No problemo!