troubleshooting Question

Microsoft Access 2003 Report Design - Eliminating White Space

Avatar of CavMom
CavMom asked on
Microsoft Access
15 Comments2 Solutions379 ViewsLast Modified:
We have a report where the design is as follows:

DocNo                 IdInfo

The IdInfo control is based upon an IIf statement to combine four fields of the table.  Summary is a Total Access Memo ActiveX add-in to allow for formatting of the text in the memo field.  In certain instances, IdInfo will contain no data and, therefore, leaves a blank space in the report.  What can we do to get rid of that blank space when there is no data to fill the IdInfo control?

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Database Architect / Application Developer
Join our community to see this answer!
Unlock 2 Answers and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros