A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

hiding control textbox when no data



 
 
Thread Tools Display Modes
  #1  
Old May 19th, 2010, 03:39 AM posted to microsoft.public.access.reports
associates
external usenet poster
 
Posts: 132
Default 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  
Old May 19th, 2010, 04:22 AM posted to microsoft.public.access.reports
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default 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  
Old May 19th, 2010, 05:28 AM posted to microsoft.public.access.reports
associates
external usenet poster
 
Posts: 132
Default 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  
Old May 19th, 2010, 04:08 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old May 20th, 2010, 12:39 AM posted to microsoft.public.access.reports
associates
external usenet poster
 
Posts: 132
Default 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  
Old May 20th, 2010, 03:42 AM posted to microsoft.public.access.reports
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default 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

  #7  
Old May 20th, 2010, 06:38 AM posted to microsoft.public.access.reports
associates
external usenet poster
 
Posts: 132
Default hiding control textbox when no data

Yes, it is looking a lot better now. It is the section that i missed out on
changing the can shrink property to Yes. It works now.

Well done and Thank you for everything.

"Duane Hookom" wrote:

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

  #8  
Old May 25th, 2010, 10:04 AM posted to microsoft.public.access.reports
Vagabond
external usenet poster
 
Posts: 7
Default hiding control textbox when no data

What if there are other items to the left or right that you don't want to
shift? The classic situation is an address section on an invoice report,
say. If one of the address fields is not being used you get the gaps.
However, if you let it expand and contract, information further to the left
or right gets broken up. What is the answer to that?

"Associates" wrote:

Yes, it is looking a lot better now. It is the section that i missed out on
changing the can shrink property to Yes. It works now.

Well done and Thank you for everything.

"Duane Hookom" wrote:

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

  #9  
Old May 25th, 2010, 01:21 PM posted to microsoft.public.access.reports
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default hiding control textbox when no data

I often use concatenated values in a single text box or query field. For
instance, in a query:

FullAddress: [CompanyName] & Chr(13) & Chr(10) &
[Address1] & Chr(13) & Chr(10) &
([Address2] + Chr(13) + Chr(10)) &
[City] & ", " & [State] & Space(3) & [Zip]

The Address2 line uses plus signs instead of ampersands for concatenation.
The reason is that if Address2 is Null, the entire expression inside the
parentheses will evaluate to Null, and there will be no vertical space where
Address2 would be.

This doesn't eliminate all difficulties, but it is one of the techniques that
can be put to use.

Vagabond wrote:
What if there are other items to the left or right that you don't want to
shift? The classic situation is an address section on an invoice report,
say. If one of the address fields is not being used you get the gaps.
However, if you let it expand and contract, information further to the left
or right gets broken up. What is the answer to that?

Yes, it is looking a lot better now. It is the section that i missed out on
changing the can shrink property to Yes. It works now.

[quoted text clipped - 74 lines]

Thank you in advance


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201005/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.