Images on Form

  • Thread starter Thread starter John R. Youngman
  • Start date Start date
J

John R. Youngman

Hi. Using Access 97 and Access 2003 for a Form that displays pictures of
members (one picture per record). It works fine when you search for a
record.

But there are some members with no picture. If I search for them it returns
a blank image where the photo should be--that's also fine. But here's the
problem:

If I'm using the record selector to view one member and then the next, if
there is no image for the next member it continues to display the last
member image found. This continues until I come across a member with a
picture, and then the correct image is displayed.

How can I force an image update (to show a blank frame) if there is no
picture? Or, if there is no picture how can I make it default to a "blank"
picture when I click next or previous?

TIA

John
 
you can force by showing a image which says no photo and
or something else like this

If IsNull(Me.SampImage) Or Me.SampImage = "Missing" Then
Me.ImageFrame.Picture = "c:\image\blank.jpg"
Else

Me.[ImageFrame].Picture = "c:\image\photo.jpg"
End If

just an logical way out, there might be another easy way
out
 
Thanks, Lance.

I'll give it a try.

John


Lance said:
you can force by showing a image which says no photo and
or something else like this

If IsNull(Me.SampImage) Or Me.SampImage = "Missing" Then
Me.ImageFrame.Picture = "c:\image\blank.jpg"
Else

Me.[ImageFrame].Picture = "c:\image\photo.jpg"
End If

just an logical way out, there might be another easy way
out
-----Original Message-----
Hi. Using Access 97 and Access 2003 for a Form that displays pictures of
members (one picture per record). It works fine when you search for a
record.

But there are some members with no picture. If I search for them it returns
a blank image where the photo should be--that's also fine. But here's the
problem:

If I'm using the record selector to view one member and then the next, if
there is no image for the next member it continues to display the last
member image found. This continues until I come across a member with a
picture, and then the correct image is displayed.

How can I force an image update (to show a blank frame) if there is no
picture? Or, if there is no picture how can I make it default to a "blank"
picture when I click next or previous?

TIA

John


.
Click to expand...
Click to expand...
 
Back
Top