Software

Ask something
Discussion Locked

Hiding duplicates creates blank lines

0 helpful
5 replies

by davidglenz

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When creating a report in Access 97 I have a whopping 2 fields that I want from the database. I add them to the report and choose HideDuplicate-Yes, CanShrink-Yes for both fields. Well, they don't show, but they do leave blank lines where they wouldhave been had they printed. End result is one goofy looking report. Is there anyway around this?

5 replies

by kees.valkenswaard

If you use hide duplicates, this will always apply to the [last] visible field. So it is very likely that one of your fields will show blank, while the other has different information.
Try another query to avoid this problem. Use a Group-by query. [With the totals button] In this way you get rid of duplicates. Use the correct sorting!
Base your report on this query.
It will work!

by seagull data services

Make sure you set Can Shrink property to yes on the report section as well as the field.
If you don't do this, the field will shrink but a blank area will be left for the area covered by the field in design view.
Hope this helps
John

This discussion is closed to new replies.