Hello,
Using Access 2007, I'm working on a form that will allow the input of the following. And then print these things on a report.
Step Number - Number Field
Step Instruction - Memo as size of description can vary
Attachment (Picture) representing the Instruction - Attachment so the picture is stored in the database.
So printing this way looks great, however, if an instruction doesn't have an attachment, the space taken up is exactly the same as with a picture. I have all the the "Can Grow" and "Can Shrink" set to yes, however this is not available on the attachment.
Does anyone know of a way to detect the presence of an attachment so I can set the height to zero if it's not there and allow the rest of the resizing settings to work on their own to resize the Detail.
I like the attachment because it is stored in a BackEnd db, and with multiple reports possible, the data changes to the new record and what's stored for it.
Thanks In Advance.
Ed
Using Access 2007, I'm working on a form that will allow the input of the following. And then print these things on a report.
Step Number - Number Field
Step Instruction - Memo as size of description can vary
Attachment (Picture) representing the Instruction - Attachment so the picture is stored in the database.
So printing this way looks great, however, if an instruction doesn't have an attachment, the space taken up is exactly the same as with a picture. I have all the the "Can Grow" and "Can Shrink" set to yes, however this is not available on the attachment.
Does anyone know of a way to detect the presence of an attachment so I can set the height to zero if it's not there and allow the rest of the resizing settings to work on their own to resize the Detail.
I like the attachment because it is stored in a BackEnd db, and with multiple reports possible, the data changes to the new record and what's stored for it.
Thanks In Advance.
Ed
