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 Rhinorhino 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
Joined
Feb 3, 2005
Messages
78
Location
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 Question
Control Blank Line Height in a Rich text control
Replies
3
Views
291
strongm
strongm
mtownbound
  • Locked
  • Question Question
Conditionally Supress Footer
Replies
11
Views
376
mtownbound
mtownbound
MochaLatte
  • Locked
  • Question Question
Hide Report Group Header 2 If detail is blank
Replies
2
Views
330
MochaLatte
MochaLatte
Trob70
  • Locked
  • Question Question
Supress Printing of a Report Row
Replies
7
Views
298
dhookom
dhookom
rotaxmax12
  • Locked
  • Question Question
Rectangles and Lines cause blank page
Replies
2
Views
194
genomon
genomon

Part and Inventory Search

Sponsor

Back
Top