Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

supress blank rows

Status
Not open for further replies.
gray78

gray78

Programmer
Feb 3, 2005
78
US
Hello!

In Access reports, is there a way to supress a blank row in a report?

I can not show duplicate records but cannot seem to get the rows(blank) to disappear from the report.

Help please!

Gray78
 
Sort by date Sort by votes
when you say blank rows, do you mean that in the underlying query of the report, the row is blank (this shouldn't happen), or do you mean within a group, there are blank records?

try setting the canshrink property of all the controls in the row to yes, or filter out the blank rows in the underlying query...

--------------------
Procrastinate Now!
 
Upvote 0 Downvote
I mean within a group there are blank records

I have set the can shrink to yes but still no luch

How would I sent the filter
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
Control Blank Line Height in a Rich text control
Replies
3
Views
116
strongm
strongm
mtownbound
  • Locked
  • Question
Conditionally Supress Footer
Replies
11
Views
92
mtownbound
mtownbound
MochaLatte
  • Locked
  • Question
Hide Report Group Header 2 If detail is blank 1
Replies
2
Views
149
MochaLatte
MochaLatte
Trob70
  • Locked
  • Question
Supress Printing of a Report Row 1
Replies
7
Views
99
dhookom
dhookom
rotaxmax12
  • Locked
  • Question
Rectangles and Lines cause blank page
Replies
2
Views
60
genomon
genomon

Part and Inventory Search

Sponsor

Back
Top