I've got a Picture box on the detail section of my report. When I created the Picture box, I had to assign a jpg file to the Picture. I have a formula for the graphic location that points to another field in the table that defines the path and filename to use.
This all works fine, almost.
If the file specified in the database doesn't exist, the file that I assigned to the Picture when I created the Picture is displayed. Also, the 1st record displayed in the report uses the Picture I assigned when I created the Picture.
1) How do I get the 1st record to display the correct image (it does exist) rather than displaying the "default" picture?
2) How can I prevent the "default" picture from being displayed when the file does not exist? I have an "Exists" field in the table that I indicates whether the file exists?
Thank you!
IP Logged