Displaying a jpg file in a field

[PortyAL]

I have a form with a OLE field. I want to be able to run a macro which inserts a particular jpg file (a scan of my signature) into the field and show the picture rather than the filename. I tried the following code but it gives the error message "Invalid use of Null"

Sub copysig_click()

Dim signame As String

signame = "i:\signature3.jpg"

FileSystem.FileCopy signame, Forms![frm sig]![signature]

End Sub

Is there an easy way to do this?

Thanks

AL

 

[The_Doc_Man]

In the image control that will contain this signature, set the properties to linked and you can also play around with the other parameters. Just before you want to print it out, put the full file spec of the JPG file in the image's .Picture property. In a report, this might be the OnFormat event for the header or footer section where the signature was destined. In a form, you might take the Form_Current event.