Detect Picture/File Presence

I am linking to photographs/pictures of employees. Some employees have a
picture.gif file while others do not have a physical file present (i.e. John
Doe has not "jdoe.gif" in the file share) depending on whether their picture
has been taken or not. Can I detect the presence/abscence of this picture
using vb code or a reporting services expression and change to a
"notavailable.gif" if the picture is not there. I'm trying to get rid of the
ugly X that appears when the file is not there.Scott:
This is what I've done to resolve this issue. I added a filename field to
the table to store the name of the image. I default it to none.gif which is
really a transparent nothing image. If I do have an image for an employee
then the name goes into the field and in the report I just display whatever
image is in the field.
HTH
Richard
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:3D75745E-4332-4D27-A9DA-41D0A33B4BF7@.microsoft.com...
>I am linking to photographs/pictures of employees. Some employees have a
> picture.gif file while others do not have a physical file present (i.e.
> John
> Doe has not "jdoe.gif" in the file share) depending on whether their
> picture
> has been taken or not. Can I detect the presence/abscence of this picture
> using vb code or a reporting services expression and change to a
> "notavailable.gif" if the picture is not there. I'm trying to get rid of
> the
> ugly X that appears when the file is not there.