Define "big space". Do you mean horizontally or vertically?
Have you set the text box Can Shrink property to Yes?

--
Duane Hookom
MS Access MVP


"Associates" wrote in message
...
Hi,

I am wondering if there is a way to hide the whole textbox control and
does
not leave big space when it has no data/value in the Access report.

Any help would be greatly appreciated.

Thank you in advance