Do not display box if no image pulled in

[duece7]

Hello,



I have a subreport built into one of my footers on a report that pulls in comments (if there are any). It's pulling in the comments fine the problem is, if there are no comments to pull in it's still displaying the box that it would have pulled them into if there were. How do I tell access to not display the box if there is no image that's pulled in?

The first image shows the box with no image and the second image shows an image pulled in.

[June7]

Comments are saved as image files?

[duece7]

Yes, more info might help. We have surveys that we receive from customers and those surveys are scanned into a database. All of the selections 1-10 etc are stored automatically but in the comments field the are stored as the image file name for example it would only show image1.tif. In the report we have built it to go out to the folder where the image files are stored and retrieve them for the corresponding question in the survey. There are some questions however, that do not have comments but those questions are still displaying the image box on the report. We don't know upfront which questions will or will not have comments as it's different each time so we have set up just to look for them and display if there.

Any way to not display the boxes if there is no image?

[June7]

You can run code that sets as not visible but the control still occupies space and that will be evident on the report. Unless code can also set the box Height to zero and then records will 'close up' to remove the white space. This code would have to be in the OnFormat event and that event only runs for PrintPreview or direct to printer.

Better might be to have an alternate "No comments." image display.

[duece7]

good idea, thanks for the help.