Insert a picture with macro

[KWarzala]

I don't know if this is even possible, but i have a form where one of the objects is a picture. i want to be able to click a check box and have a macro automatically insert a picture on top of that picture. I want to still be able to see the picture underneath though.

The original picture that is already there is a picture of a person, and i want to insert an X on top of the picture, and still see the person under it. is this possible?

[dcrake]

What I would be tempted to do is to create a label that has an X as the caption and position this over the image and make it visible/invisible according the check box value.

Don't think Access supports transparant images that well.

David

[KWarzala]

Thank you, that will probably work. is there any way to make the font any bigger than 127? also, how do you make it visible/invisible? i set the label properties to visible: no, but i don't know what to do next. thank you for your help!

[dcrake]

The font size is dependant on the font chosen, try a winding font.

To make the label visible or invisible based on what the tick box value is , is a follows:

 
Private Sub ChkBox_Click()
If Me.ChkBox = True Then
  Me.Label.Visible = True
Else
  Me.Label.Visible = False
End If
End Sub

[KWarzala]

It worked!!! thank you so much

[KWarzala]

oops, actually when i tried it, it made the x show up on all the records, how can i limit it to the record i'm on?

[dcrake]

Something tells me you are using a continuous form? You may need to look at conditional formatting or using the on current event of the form

[KWarzala]

it's single form view. how do i use the on current?

[KWarzala]

i think i got it