hiding duplicates AND spaces

A

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!
 
C

Cheryl Fischer

Aaron,

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