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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ignore blank fields in a report

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
I'm producing a report with multiple fields for organization name and address. Such as Org1, Org2, Org3 and Add1, Add2, Add3. In my report I place the ach of these fields on a separate row and I want to eliminate the blank space when there is no Org 2 or Org3 before Add1 displays.
 
Sort by date Sort by votes
Try enabling the Can Shrink property from the Details property tab. This should help eliminate some white space.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
304
atadbitslow
atadbitslow
renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
365
renigar
renigar
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
633
TheresAlwaysAWay
TheresAlwaysAWay
Bennie47250
  • Locked
  • Question
Report Crashes
Replies
2
Views
105
kray4660
kray4660
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
100
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top