If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
a2007 images in continiuos forms
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 |
#2
|
|||
|
|||
a2007 images in continiuos forms
apoligies for the duplication. got error message on first attempt so thought
it wasnt submitted. "StuJol" wrote: 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 |
#3
|
|||
|
|||
a2007 images in continiuos forms
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 "StuJol" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|