What you are describing is vertical not horizontal.

I asked a question in my previous post that you did not answer.

--
Duane Hookom
Microsoft Access MVP


"Associates" wrote:

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