a2007 images in continiuos forms

[StuJol]

using access 2007, i have a continuious form. i trying to get an image to be
visible/invisible on every record dependant on a date value within the record.

i know i can use the image source to reference a file path but im unable to
get the code to repeat for every record. this is the simple code i have so far

Private Sub Form_Current()
If Me.Date = Date Then
Me.Image60.visible = True
MsgBox "true"
Else
Me.Image60.visible = False
MsgBox "false"
End If
End Sub

 

[StuJol]

apoligies for the duplication. got error message on first attempt so thought
it wasnt submitted.

 

[Gina Whipp]

StuJol,

I hat to be the bearer of bad news but what you are trying to do will not
work on a continuous form. Look at your code it's the same control you are
tyring make Visible/Invisible. And unfortunately, I have no solution for
you as Conditional Formatting can't be applied to Image controls.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm