Wide Open Spaces

[Owen]

Hello,

I have a report in which I want to hide duplicates, which
I can do, but I get all kinds of blank space between the
hidden duplicates and the next new data.

What can I do?

TIA

Owen

 

[Jesse Avilés]

Create a query and on the total row use the Group by option to return only
the first value without duplicates.

 

[Dennis Schmidt]

Hi Owen,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

As long as the row in the report only contains one field, you can eliminate
the space as follows:

1-Set your detail section property CanShrink and CanGrow to yes.
2-Set your textbox property CanShrink and CanGrow to yes.
3-Set your text box property HideDuplicates to yes.

You should then only see 1 row per textbox value and no space in between.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support