hiding duplicates AND spaces

[AaronG]

I'm trying to create a report based on a query that I've
made. They query has duplicate values, so I select "Yes"
to "Hide Duplicate Values" in the properties of the field
on the report. This hides the duplicates, but leaves a
blank space where it would have been. How do I get rid of
this?

Thanks for the help!

 

[Cheryl Fischer]

Aaron,

Try setting the CanShrink property of the control or controls to 'Yes'.

 

[AaronG]

Cheryl,

I tried that already but it didn't help. Any other ideas?