How to use Visible YES/NO in reports

[yus786]

I'm struggling with this.

I need to have an expression in my report where it would look at the value of a field, then use the visible YES/NO on a text box.

I can do this within a form by using txtbox.value function - but can't seem to do this in my report.

Please help...

 

[yus786]

Anyone please?

There must be someone out there who knows how to do this?

 

[boblarson]

Use Conditional Formatting. Set the conditional format of that visible field to be

Is Expression

and the expression something like

[YourOtherField]="Something"

And then in the format there is a button for VISIBLE.

Hopefully that helps as I can't post a screenshot at the moment.

 

[yus786]

Use Conditional Formatting. Set the conditional format of that visible field to be

Is Expression

and the expression something like

[YourOtherField]="Something"

And then in the format there is a button for VISIBLE.

Hopefully that helps as I can't post a screenshot at the moment.

Thanks for helping Bob but i dont understand what you mean.

Could i please have some examples?

• txtLineNumber will have values from 1 to 20
• If the value of txtLineNumber is between 4 to 20, i want this label field called lblPos to not appear i.e the visible property to be No

Thanks again