Access 2002 or 2003

S

SteveJ

Can anyone tell me whether report group headers in either of these products
have the CanShrink property? I'm using 2000 at the moment which only has
this property in the detail part of a report and I have a problem which
would be resolved by this feature.

TIA
Steve
 
A

Allen Browne

Hi Steve

Group headers do have Can Grow and Can Shrink properties, even in A2000.
 
R

Rick Brandt

SteveJ said:
Can anyone tell me whether report group headers in either of these products
have the CanShrink property? I'm using 2000 at the moment which only has
this property in the detail part of a report and I have a problem which
would be resolved by this feature.
Click to expand...

You're incorrect. The only sections that can't shrink/grow are Page
Header/Footers. All others can (in all versions at least back to 95).
 
S

SteveJ

Allen/Rick

You are both correct. I was mistakenly checking the page headers/footers.

However, I have manged to resolve my problem and thought it might be worth
passing on.

The problem is that in a group header (which contains 3-5 lines of address
data), my client wanted the text spacing out by a few millimetres more -
fussy or what!

I've eventually done this by having separate address text boxes for each
line with CanShrink = Yes. Behind these, I've placed another set of text
boxes - the record source for these is iif(IsNull([ADDRESS1], "", "A") and
to increase the spacing, I've set these to a bold font. If any line is
printed then the line spacing is based off the bold "A" rather than the
normal font weight. I did try using the line spacing field for text boxes
but when set to even the smallest value, it chopped the last line of print.

At least I don't now have to buy Crystal Reports!

Thanks for you input.

Steve
 
Top