Can Shrink

Stupid question, but If you make something invisable, then on top of that
have a field, that is can shrink. Does that count, or will it not shrink
above the invisable text box?

The control will still shrink regardless of the hidden control If there is
anything visible alongside the shrinkable control, however, then it won't
shrink. For instance if you have a label you want to hide if a control
shrinks if it has no data then you should hide the label by putting code in
the relevant section's Format event procedure, e.g.

Me.MyLabel.Visible = Not IsNull(Me.MyBoundControl)

The bound control will then shrink to nothing if Null and the label will be
hidden.

Ken Sheridan
Stafford, England


"Chey" wrote:

Stupid question, but If you make something invisable, then on top of that
have a field, that is can shrink. Does that count, or will it not shrink
above the invisable text box?

So I took out all the labels
But I have a field that is invisable, then on top of that I have a formual.
Then I have a subreport that I have done the same with.
How do I get the subreport to do the same?
I don't want any blank pages.
Thanks

"Ken Sheridan" wrote:

The control will still shrink regardless of the hidden control If there is
anything visible alongside the shrinkable control, however, then it won't
shrink. For instance if you have a label you want to hide if a control
shrinks if it has no data then you should hide the label by putting code in
the relevant section's Format event procedure, e.g.

Me.MyLabel.Visible = Not IsNull(Me.MyBoundControl)

The bound control will then shrink to nothing if Null and the label will be
hidden.

Ken Sheridan
Stafford, England


"Chey" wrote:

Stupid question, but If you make something invisable, then on top of that
have a field, that is can shrink. Does that count, or will it not shrink
above the invisable text box?

Are you saying that you want to hide the subreport if it has no data? If so,
reports have a NoData property, so you can hide the subreport 'control', i.e.
the control in the parent report which houses the subreport, by putting code
in the Format event procedure of whichever section of the parent report
contains the subreport:

Me.MySubreportControl.Visible = Me.MySubreportControl.Report.HasData

Ken Sheridan
Stafford, England

"Chey" wrote:

So I took out all the labels
But I have a field that is invisable, then on top of that I have a formual.
Then I have a subreport that I have done the same with.
How do I get the subreport to do the same?
I don't want any blank pages.
Thanks

I am actually trying to achive something else, but tried this route first
I have a query and all I want to do is view a select part of data.
I want to see if a provider has had a check box for a period of 6 months.
So what I did was make a report with a vendor number
and on my subreport the months. Everything looked okay until, I did the
formula
iif a field is greater than 6 then visable if not then null. That worked
to. However I had to many blank pages.

Now what. Any suggestions.


"Ken Sheridan" wrote:

Are you saying that you want to hide the subreport if it has no data? If so,
reports have a NoData property, so you can hide the subreport 'control', i.e.
the control in the parent report which houses the subreport, by putting code
in the Format event procedure of whichever section of the parent report
contains the subreport:

Me.MySubreportControl.Visible = Me.MySubreportControl.Report.HasData

Ken Sheridan
Stafford, England

"Chey" wrote:

So I took out all the labels
But I have a field that is invisable, then on top of that I have a formual.
Then I have a subreport that I have done the same with.
How do I get the subreport to do the same?
I don't want any blank pages.
Thanks

I'd think there's probably an easier way using a query, on which you can then
base a simple report. If you can post details of the table(s) involved and,
if there's more than one, how they are related, along with an exact
description of what you want then hopefully I might be able to come up with
something.

I don't know what time it is where you are but its time to hit the sack
here, so I'll pick up anything you post tomorrow.

Ken Sheridan
Stafford, England

"Chey" wrote:

I am actually trying to achive something else, but tried this route first
I have a query and all I want to do is view a select part of data.
I want to see if a provider has had a check box for a period of 6 months.
So what I did was make a report with a vendor number
and on my subreport the months. Everything looked okay until, I did the
formula
iif a field is greater than 6 then visable if not then null. That worked
to. However I had to many blank pages.

Now what. Any suggestions.