hiding control textbox when no data
Thank Duane for your reply.
By "big space", I mean horizontally big space like the example below
textbox control 1
textbox control 2
textbox control 3
if there is no data/value for textbox control 2, it shows like the following
in the report
electronic
aerospace
There is a blank line in between electronic and aerospace in the report as
result of textbox control 2 contains no data.
What I hope to see is as follows
electronic
aerospace
the vacant line is replaced by the data in textbox control 3.
I wonder if this is feasible in Access report.
Thank you in advance
"Duane Hookom" wrote:
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
|