Hide textbox control in the Access report

[associates]

Hi,

I was wondering if I could get some assistance with my Access 2010 report query. How do I hide a text box control when the value is NULL in the Access report?

What happens now is I got empty spaces showing in the report when there are no values.

Any help would be greatly appreciated.

Thank you in advance

 

[boblarson]

First off try setting the CAN SHRINK property, of both the text box and the section it is in, to YES.

 

[associates]

Thank you for your reply.

Just wanna tell you that it works like a charm now. Thanks a lot for your assistance.

Good on you