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
                            Summary

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?

Thanks!
ASKER CERTIFIED SOLUTION
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