Results 1 to 2 of 2
  1. #1
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291

    Seeing Image from Previous record ......


    I have a report that I have an image that is linked to a path, I set the image with the file path from a text box in this way;

    Me!imgPicture1.Picture = Me.txtPicture1.Text

    This works fine except when Me.txtPicture1.Text="" In this case it just displays the picture from the previous record. How do I clear the image to be blank instead of adopting previous records images?

  2. #2
    Jamy is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    36
    In my understanding the report needs to be in print preview and the code should be in the on format event. Can you let me know if this is the case?

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

Similar Threads

  1. SQL Subquery on Previous Record
    By GoVols02 in forum Queries
    Replies: 1
    Last Post: 01-05-2010, 02:40 PM
  2. Replies: 2
    Last Post: 11-04-2009, 09:45 PM
  3. Populate date from previous record
    By Lianes in forum Access
    Replies: 3
    Last Post: 09-19-2009, 03:42 PM
  4. Add data from previous record if blank
    By mbc321 in forum Queries
    Replies: 1
    Last Post: 08-08-2009, 05:15 PM
  5. using value from previous record
    By dollars in forum Queries
    Replies: 0
    Last Post: 12-10-2008, 03:30 PM

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