Forum home » Delegate support and help forum » Microsoft Access Training and help » Reports
|
|
|
The UK's most regular 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. |
Reports
Resolved · Low Priority · Version 2003
Reply Fri 20 Aug 2010, 16:21Delegate Elisya said...
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!
For upcoming training course dates see: Pricing & availability
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
|