98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Reports
Reports
Resolved · Low Priority · Version 2003
Elisya has attended:
Access Advanced course
Access Intermediate course
Reports
When producing reports, users have requested that the reports do not publish fields which are blank. Concurrently, the layout of the report is affected as the (completed) fields around the blank field should shift accordingly, so that there aren't any strange gaps in the layout of the report. How do I do this? I know how to change the visibility of the fields, but not how to shift the other fields automatically. Please help!
RE: Reports
Hi Elisya, thanks for your query and welcome to the forum. I have done some digging and found the following link which I think might solve your problem. It involves modifying the CanShrink property of the controls on your report. Have a read of this:
http://tinyurl.com/accessreportfields
Try this out and let me know how you get on.
All the best,
Anthony
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Create own ribbon tab - Access 2010a. In Access click on the File tab |