Call/display image or text on demand as background to a specific record.

[usmanghani_2654]

hi all,
I have a lost/found property database form (soft-copy), it works perfectly fine. We enter the details of the found property and then take the print (hard-copy) of the form. Whenever an owner comes to claim his/her item we search through our soft-copy for the specific item/record and then ask them to sign on the relevant hard-copy record after which we cross out the hard-copy and write with a permanent marker "Restored". Whereas in the soft-copy we type in the details that it has been claimed/restored in available text fields.
However, is there anyway that I can display a big large banner saying "restored" in front of only that record(s) where item(s) has been restored to the owner. It doesn't have to be a text banner/label, it could also be a picture saying "Restored". I have manage to get a print message box set-up for this but it's too annoying. Every time we pull out an item's record that has been restored, that message box comes up and then we have to click OK to proceed. I can remove it but only if can find a replacement. See attachment please.


Any help would be much obliged.

[amrut]

Try this -
Add an image to the form say ImgRestore and set its visibility in the form's current event based on the field that determines whether an item has been restored or not. You can use a label with a caption "Restored" instead of image.
Like
If YourFieldName=True then ( Item is restored)
Me.ImgRestore.Visible=True
Else
Me.ImgRestore.Visible=False
Endif

[thebigthing313]

You can have a label (or a picture) whose visibility is conditional to if the current record is claimed/restored.

I wouldn't plaster it across the entire form, but most likely at the top of the form. In the Form's On Current event, you would test for Claimed/Restored status, and set visibility accordingly. Something like this:

Private Sub Form_Current()
  Me.ImageControl.Visible = Me.RestoredStatus
End Sub