Can Shrink won't shrink in ACC 97 
Author Message
 Can Shrink won't shrink in ACC 97

I have converted a program from access 2.0 to access 97 and the fields
on a report that will shrink on access 2.0 will not shrink in access 97.
If I remove the label on the left side of the report (which I need to
show what the information is all about) then the line will shrink. The
label does not have a 'Can Shrink' property.
  What can I do? I have thought of building a file that has the label
information in it, but then the line would probably not shrink because
data would then exist on the line.
  I have searched the Microsoft.Com library but did not find anything.
Why would Microsoft change this? What can I do?

Any suggestions would be very much appreciated.

Terry



Thu, 22 Feb 2001 03:00:00 GMT  
 Can Shrink won't shrink in ACC 97
Why do you want it to shrink?
If it is to eliminate Null values , then just re-design the query to do
that.
Quote:

>I have converted a program from access 2.0 to access 97 and the fields
>on a report that will shrink on access 2.0 will not shrink in access 97.
>If I remove the label on the left side of the report (which I need to
>show what the information is all about) then the line will shrink. The
>label does not have a 'Can Shrink' property.
>  What can I do? I have thought of building a file that has the label
>information in it, but then the line would probably not shrink because
>data would then exist on the line.
>  I have searched the Microsoft.Com library but did not find anything.
>Why would Microsoft change this? What can I do?

>Any suggestions would be very much appreciated.

>Terry



Thu, 22 Feb 2001 03:00:00 GMT  
 Can Shrink won't shrink in ACC 97
I am having a similar problem with the can grow property.  I am trying to
print out mailing labels with 5 fields for the address.  Name, Company,
Address1, Address 2, City, State, zip.  Anyway, if I set any of these fields
in the report to CANNOT GROW than the entire line is left blank?  Who knows
maybe these problems have the same underlying solution.

Shawn Bochman

Quote:

>I have converted a program from access 2.0 to access 97 and the fields
>on a report that will shrink on access 2.0 will not shrink in access 97.
>If I remove the label on the left side of the report (which I need to
>show what the information is all about) then the line will shrink. The
>label does not have a 'Can Shrink' property.
>  What can I do? I have thought of building a file that has the label
>information in it, but then the line would probably not shrink because
>data would then exist on the line.
>  I have searched the Microsoft.Com library but did not find anything.
>Why would Microsoft change this? What can I do?

>Any suggestions would be very much appreciated.

>Terry



Sun, 25 Feb 2001 03:00:00 GMT  
 Can Shrink won't shrink in ACC 97
Use an IIF statement to print the label and the data.

IIF(ISNULL(data), "", "Label:  " & [Data])
--
candice L. Meyer



Quote:
> I have converted a program from access 2.0 to access 97 and the fields
> on a report that will shrink on access 2.0 will not shrink in access 97.
> If I remove the label on the left side of the report (which I need to
> show what the information is all about) then the line will shrink. The
> label does not have a 'Can Shrink' property.
>   What can I do? I have thought of building a file that has the label
> information in it, but then the line would probably not shrink because
> data would then exist on the line.
>   I have searched the Microsoft.Com library but did not find anything.
> Why would Microsoft change this? What can I do?

> Any suggestions would be very much appreciated.

> Terry



Tue, 06 Mar 2001 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Can Shrink=Yes Will Shrink=no

2. Can Shrink wont shrink

3. PST file won't shrink.

4. Subforms won't grow or shrink

5. SubReports won't shrink!

6. Help: Detail section won't grow/shrink, Access 2.0

7. Report that won't shrink

8. Access 2 to '97: Shrink Field

9. 'Can Shrink' on report

10. Excel 97 Shrinking Columns


 
Powered by phpBB® Forum Software © phpBB Group