Wide Open Spaces

  • Thread starter Thread starter Owen
  • Start date Start date
O

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
 
Create a query and on the total row use the Group by option to return only
the first value without duplicates.
 
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
 
Back
Top