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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating bolded text exclusively. 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Hiding Duplicates 9
Remove extra space in a Report 1
Wrapping and Anchors 0
Space at end of multi page list to accommodate new entries 1
Insert Index into a Table 1
Record omission 2

Top