Hello all! I'd like to create an image in my "Continuous form" that is circumstantially visible. The image will always be the same... a simple jpg.
As you're scrolling through the continuous form and the records are flying by, I'd like that image to be visible IF a certain condition is met.
"IF a Boolean Field [HasImage] = True, THEN make that image visible."
Alternatively I could make it visible if it belong to a record whose creation date field was within 48 hours old.
The first place my mind goes right to is "Conditional Formatting", but that only works for textboxes I think.
The second place my mind goes to is to create some code in the CurrentRecord or some such, but I'm not sure the correct event. The whole thing feels forced.
The third idea I had was to create an IIF() statement within the Control Source of an image control ... but I couldn't easily foresee where I needed to go with it.
I'm not sure if I'm barking up the right tree.
What is the wise way to approach this simple task?
Matt
*PS: I don't care whether it's preferable to keep the JPG in a folder adjacent to the ACCDB file, or to save it in an Attachment field in a table somehow. Whichever makes the job here easier.