Can Shrink=Yes Will Shrink=no 
Author Message
 Can Shrink=Yes Will Shrink=no

Please could someone advise me on clearing up white space
on a report, once a record has been hidden?

I've set the controls to can shrink= yes, and ditto with
the detail section on the report, but the space remains.

There are no other controls on the same horizontal plane.

Is there any way to forcibly close up the space?

regards and many thanks

Johnny



Sat, 11 Sep 2004 21:19:39 GMT  
 Can Shrink=Yes Will Shrink=no
Do you have any overlapping controls?
That will sometimes prevent shrinking.
Also, do you have a rectangle or vertical line which may be preventing
shrinking?

HTH
    - Turtle


Quote:
> Please could someone advise me on clearing up white space
> on a report, once a record has been hidden?

> I've set the controls to can shrink= yes, and ditto with
> the detail section on the report, but the space remains.

> There are no other controls on the same horizontal plane.

> Is there any way to forcibly close up the space?

> regards and many thanks

> Johnny



Sun, 12 Sep 2004 01:33:54 GMT  
 Can Shrink=Yes Will Shrink=no
Johnny:

I can't tell you why the white space is remaining (Turtle has provided you with some possibilities),
but you can also control the visibility of the entire section in question based on an expression.
This will eliminate any part of the section from printing if that is what is desired:

Me.Detail.Visible = Not IsNull(Me.MyControl.Value)
--
Bruce M. Thompson, Microsoft Access MVP

Quote:
>>No Email, Please. Keep all communications

    within the newsgroups so that all might benefit.<<
Quote:

> Please could someone advise me on clearing up white space
> on a report, once a record has been hidden?

> I've set the controls to can shrink= yes, and ditto with
> the detail section on the report, but the space remains.

> There are no other controls on the same horizontal plane.

> Is there any way to forcibly close up the space?

> regards and many thanks

> Johnny



Sun, 12 Sep 2004 01:48:03 GMT  
 Can Shrink=Yes Will Shrink=no
Thanks for your help guys.

For some reason the space simply will not shrink. There
are no lines and no overlaps, and all properties checked
out. I didn't want to hide the whole section, just various
records.
I've now tried a different tact when hiding the
duplicates - query dumped to an indexed table - so this is
a moot point.

Thanks for the replies anyway!

Johnny

Quote:
>-----Original Message-----
>Please could someone advise me on clearing up white space
>on a report, once a record has been hidden?

>I've set the controls to can shrink= yes, and ditto with
>the detail section on the report, but the space remains.

>There are no other controls on the same horizontal plane.

>Is there any way to forcibly close up the space?

>regards and many thanks

>Johnny
>.



Sun, 12 Sep 2004 16:26:34 GMT  
 Can Shrink=Yes Will Shrink=no

Quote:
> out. I didn't want to hide the whole section, just various
> records.

FYI: The detail section represents *one* record so, if you want to hide one record, you can simply
hide the "whole" detail section for that record. Seems like a waste of space to create a separate
table just to hide a few records?!
--
Bruce M. Thompson, Microsoft Access MVP

Quote:
>>No Email, Please. Keep all communications

    within the newsgroups so that all might benefit.<<


Sun, 12 Sep 2004 21:47:58 GMT  
 Can Shrink=Yes Will Shrink=no
You may be right. I'll give your suggestion a go. Thanks!

Quote:
>-----Original Message-----
>> out. I didn't want to hide the whole section, just
various
>> records.

>FYI: The detail section represents *one* record so, if

you want to hide one record, you can simply
Quote:
>hide the "whole" detail section for that record. Seems

like a waste of space to create a separate
Quote:
>table just to hide a few records?!
>--
>Bruce M. Thompson, Microsoft Access MVP

>>>No Email, Please. Keep all communications
>    within the newsgroups so that all might benefit.<<

>.



Mon, 13 Sep 2004 17:59:19 GMT  
 Can Shrink=Yes Will Shrink=no


Quote:
> Please could someone advise me on clearing up white space
> on a report, once a record has been hidden?

> I've set the controls to can shrink= yes, and ditto with
> the detail section on the report, but the space remains.

> There are no other controls on the same horizontal plane.

> Is there any way to forcibly close up the space?

> regards and many thanks

> Johnny



Sat, 25 Sep 2004 17:01:30 GMT  
 
 [ 7 post ] 

 Relevant Pages 

1. Can Shrink wont shrink

2. Can Shrink won't shrink in ACC 97

3. Can Shrink Yes/No Fields

4. shrink to fit does it creat a new format in a cell if the text shrinks?

5. How to Shrink Outlook.pst file?

6. Shrinking file

7. "reply to" shrinks fonts

8. Shrinking PST file size

9. PST file won't shrink.

10. Shrinking outlook.pst size


 
Powered by phpBB® Forum Software © phpBB Group