Subtitituing Yes/No value with jpeg in Access 2K3

S

Sokan33

How can I substitute a Yes/No value with a jpeg image of a checkmark or X
respectively? Thanks!
 
J

jmonty

Let's say the Yes/No field is called chkPicture
Set the Visible property for chkPicture to No.
Make the OLE (picture) object Visible = Yes.
In the On Change event of the Yes/No field add the logic to see if it is
Yes/True.

If Me.chkPicture = True then

Me.olePicture = "C:\MyPicture.jpg" 'or whatever field or variable that
contains the file name
End If
 
Top