a2007 images in continiuos forms

  • Thread starter Thread starter StuJol
  • Start date Start date
S

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
 
apoligies for the duplication. got error message on first attempt so thought
it wasnt submitted.
 
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
 
Back
Top