If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
controlling the appearance of data
I have a main report with 3 sub reports in it. Each sub report is based on a
query. If there is no data on a particular person in one of the 3 subreport queries, the subreport contents do not show up on the main report - and vice versa. This is what I want. My question is how can I get the space where the subreport contents usually shows up to just say something like "No Data Available" if that is the case? Thank you. |
#2
|
|||
|
|||
controlling the appearance of data
G. wrote:
I have a main report with 3 sub reports in it. Each sub report is based on a query. If there is no data on a particular person in one of the 3 subreport queries, the subreport contents do not show up on the main report - and vice versa. This is what I want. My question is how can I get the space where the subreport contents usually shows up to just say something like "No Data Available" if that is the case? Thank you. Create a label control (named lblrpt1) and place it in subreport1's area. Set its Caption to whatever you want. Then add a line of code to the section's Format event procedu Me.lblrpt1.Visible = Not Me.subreport1.Report.HasData Trpeat for the other subreports. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|