Let me first say I'm a beginner in Access so please go easy on me, but assume I know nothing.

I have an inspection database in 2007 that describes the condition of systems throughout a home. Some of these systems will have related images for further description to the customer. I used an Attachment field in the table and the form works great.

My problem is in the report. Because some the the Attachment fields my be left empty I would like to use the Can Shrink / Can Grow property to remove the Attachment field from the report just like you can do with a text field. But, there is no Can Shrink / Can Grow property for the Attachment field type.

Can anyone offer any type of solution or suggestion on how to remove/hide empty Attachment fields and remove the empty space in a report?


Thanks,
Jason