If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
hiding control textbox when no data
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 |
#2
|
|||
|
|||
hiding control textbox when no data
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
hiding control textbox when no data
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 |
#5
|
|||
|
|||
hiding control textbox when no data
Thank you Duane for your reply.
Sorry that I misunderstood your question regarding horizontal or vertical. Thanks for clarifying that. The other question I did not realise that I had not answered it. Sorry about that. I did try to use the "can shrink" property and set it to Yes and it still leaves that gap (blank lines) in the report. However, what i have done now is i have downsized the textbox control to some extent that you can only see a tiny box. It works allright but not that perfect. I think I can live with that. If you have any other ideas you think that may work for me, I am more than happy to appreciate it. Thank you once again for your help "Duane Hookom" wrote: 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 |
#6
|
|||
|
|||
hiding control textbox when no data
Typically if the text box can shrink and the section can shrink and there
are no controls to the left or right of the text box, the gap will shrink. -- Duane Hookom MS Access MVP "Associates" wrote in message ... Thank you Duane for your reply. Sorry that I misunderstood your question regarding horizontal or vertical. Thanks for clarifying that. The other question I did not realise that I had not answered it. Sorry about that. I did try to use the "can shrink" property and set it to Yes and it still leaves that gap (blank lines) in the report. However, what i have done now is i have downsized the textbox control to some extent that you can only see a tiny box. It works allright but not that perfect. I think I can live with that. If you have any other ideas you think that may work for me, I am more than happy to appreciate it. Thank you once again for your help "Duane Hookom" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|