In form view, I would like my form background to change based on the contents of one of the fields as I arrow through the records.
In form view, I would like my form background to change based on the contents of one of the fields as I arrow through the records.
This can be done with VBA code in the form's Current event. Examples:
Referenced field has name of image file:Code:Private Sub Form_Current() If Me.somefield = "this value" Then Me.Picture = "C:\Images\Image1.png" Else Me.Picture = "C:\Images\Image2.png" End If End Sub
Code:Private Sub Form_Current() Me.Picture = "C:\Images\" & Me.ImageName End Sub
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.