Hi, I a several subforms in a report and for some records the subforms do not return any data. When this happens, I would like to display a message as at present the area normally occupied by the subform is simply blank. Can anyone help me? Thanks in advance.
-
-
Hi garfieldsevilla
What I do is to have a hidden label (or could be an image) on top of the subreport. In the detail event of the main report, I run a dcount, to check whether the subreport will have any records, and if not, I change the visibility of the label. -
hi, thanks for your reply.
Could you elaborate? I'm using A2003 and do not see a detail event control in the report properties box.
Also, each record is being printed on a new page, and each page has a new set of subdata. Will this work? Sorry, I'm not a very advanced access user.Comment
-
Hi garfield.
I made a video as an example to illustrate.
Comment
-
Thank you for taking the time to record this. My reports now have messages when there is no data in the subform!Comment
-
Im glad to hear that.
Note that you can use an image instead of a label if you prefer. The method is the same.Comment
Comment