Embedd picture in Report

[lcook1974]

Hi,
I have a database "report" that is actually a letter head statement that will be sent to different hospitals based on the donor and different procedures completed.

There will be a total of 6 people using the database.

What I want to do is have a "hidden" picture of their signature and based on who the choose in the drop down (sending the letter) it will show their signature.

What I can get it to do:

1. Show the signature when I place the code in the "on current" event...but only after they actually click on the report.
2. Get it to save the report to a folder, open an email object and attached that report.

The problem:

1. Show the signature "right off the bat"...
2. Saving the signature to the "Saved" file.

Can anyone help me out with how to show this signature?

Below is the code I have it the report:

Private Sub Report_Current()
If Me.Text31 = "User1" Then
    Me.User1.Visible = True
ElseIf Me.Text31 = "User2" Then
    Me.User2.Visible = True
End If
End Sub

 

[EternalMyrtle]

When you click on the signature control in Design view does it say "Screen Only" in the Display properties? If so, change it to Always.

Did you try Requerying the signature field?

So, Me.User2.Requery

 

[pr2-eugin]

Move the code to ReportDetail_OnFormat method. Although this will be available only in Preview mode, if you want to print out, I dont think this would work ! Not 100% sure !