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
|
|||
|
|||
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? |
#2
|
|||
|
|||
Can Shrink
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? |
#3
|
|||
|
|||
Can Shrink
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? |
#4
|
|||
|
|||
Can Shrink
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 |
#5
|
|||
|
|||
Can Shrink
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 |
#6
|
|||
|
|||
Can Shrink
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to tell if cell contains a FORMULA or user-entered number? | rcmodelr | Worksheet Functions | 11 | July 30th, 2008 01:47 AM |
Shrink not working ?!? | mscertified | Setting Up & Running Reports | 2 | January 11th, 2006 05:52 PM |
Can Shrink property | ctdak | Setting Up & Running Reports | 2 | December 21st, 2005 07:14 PM |
One record one page shrink grow within single page | Steve'o | Setting Up & Running Reports | 1 | February 1st, 2005 01:47 PM |
how to shrink photo to send via email | Chrystel ball | General Discussion | 2 | October 18th, 2004 10:45 PM |