Access 2002 or 2003

[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

 

[Allen Browne]

Hi Steve

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

 

[Rick Brandt]

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.

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).

 

[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