Results 1 to 3 of 3
  1. #1
    MatthewGrace is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2013
    Posts
    159

    An image in Continuous Form View

    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.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    The image box will ALWAYS be visible.
    if it doesn't have an image,it won't be seen.

  3. #3
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,654
    I use a "No Photo" image and use it as the ValueIsNull argument in an NZ(). (i.e. = Nz(YourImage,NoPhotoImage))
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 10-30-2020, 05:14 PM
  2. Replies: 5
    Last Post: 02-13-2019, 05:03 PM
  3. Replies: 16
    Last Post: 03-26-2015, 08:35 PM
  4. Replies: 3
    Last Post: 10-12-2012, 01:38 PM
  5. Replies: 2
    Last Post: 10-10-2011, 10:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums