Show/hide textbox control on report

Topic

New Reply

How can I show or hide a textbox control on a report based on whether the field (for that record) that the control is bound to is empty? Specifically, I can’t figure out how to test for the existence of data in the field

Reply | Quote

Replies

Use the Len() function to test the length of the field value concatenated to an empty string, like this:

Len([Field1] & “”)>0

Reply | Quote