Hide an attachment in a report

[FJM]

I have a form which collects data and then sends the records to a report.


One of the controls on the form is a YES/NO button which asks the user whether an attachment is available for the particular record.
If the answer is YES I want the attachment to appear on the report
If the answer is NO then I don't want the attachment to appear on the report.
Is this possible and if so any pointers as to how ?

[ranman256]

How are you sending the email...
if docmd.output method

'scroll thru your users list
if tUsers.Send then
docmd.output report...
end if

'if email.send method then dont use the email.attach option

[June7]

Is this to send email with attachment?

Do you want to dynamically display images on Access report? For Access 2003 review http://support.microsoft.com/kb/285820

[FJM]

I think I may have not explained what I need properly.
I have a data entry form which is used to collect data about a part number.
The user fills in the data on the form and then once complete, this data is stored within the database and is used to produce an inspection report for the part number.
The user can choose to view the report by choosing a part number from a combo box.
On the data entry form I have put a check box to indicate whether an attachment is available for the part number (this attachment gives additional details) and where applicable have attached the details within the forms table.
What I now need to happen is that when the user goes to the combo box and chooses a part number, the inspection report will come into view and if the check box is ticked then the attachment appears. If the check box is unticked then I do not want the attachment to appear.
It has nothing to do with e-mails.

[June7]

What is 'attachment' - just another Access report or an external file?

[FJM]

The attachment is a JPEG image which is one of the fields in the Table which is the source which runs the query which runs the report

[June7]

You are using Access 2003?
What kind of field - OLEObject?
Did you review the link I posted?

[FJM]

I am using Access 2007
The field is an attachment field as selected when the Table was designed
I did not see a link in your post - did I miss it ?

[June7]

In post 3 but since you have Access 2007, just disregard. (Might change your profile.)

Use an Image control to dynamically display jpeg images from the attachment field.

Set ControlSource property.

[FJM]

How does this link to the Yes/No button which the user changes to suit the individual part

[June7]

Maybe don't need button.

If there is nothing in the attachment field then nothing will show in the Image control.

Why should user have to know if there is an attachment?

[FJM]

I want the image control to not show on the report if the user has not checked the YES/NO button.
Some parts will have an image and some parts will not

[June7]

Programmatically removing control from report is a design modification and requires opening report in Design view. I don't think removing control is practical if report shows multiple records.

Suggest you have a 'placeholder' image - a jpeg that just says 'no image available'.