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
|
|||
|
|||
Subreport is empty...need to show "No Records Found"
I have a report with a subreport. I understand that when there are no records
in the subreport then it will display empty. I read in another thread that you can put a control behind the subreport that will be visible when the subreport is empty. I am trying to do this with a control that ="No Records Found", but the control still shows up when the subreport has data. I tried the On Format suggestion, but did not work out. I am a novice, so it was probably my mistake...any further help is much appreciated. -- Kbelo |
#2
|
|||
|
|||
Subreport is empty...need to show "No Records Found"
Set the control source to something like:
=IIf(sbrptctrlName.Report.HasData,Null, "NO DATA") -- Duane Hookom Microsoft Access MVP "Kathy" wrote: I have a report with a subreport. I understand that when there are no records in the subreport then it will display empty. I read in another thread that you can put a control behind the subreport that will be visible when the subreport is empty. I am trying to do this with a control that ="No Records Found", but the control still shows up when the subreport has data. I tried the On Format suggestion, but did not work out. I am a novice, so it was probably my mistake...any further help is much appreciated. -- Kbelo |
#3
|
|||
|
|||
Subreport is empty...need to show "No Records Found"
Thank you for your reply. I am still having problems...sorry, I am probably
doing something "obvious", but just not to me. Anyway, this is what I am entering in an unbound textbox on the main form (not subform): =IIf(strStatus.Report.HasData, Null, "No Data") strStatus is on the subForm. But I am getting "#Name?" as the response. Again many thanks for your help. -- Kbelo "Duane Hookom" wrote: Set the control source to something like: =IIf(sbrptctrlName.Report.HasData,Null, "NO DATA") -- Duane Hookom Microsoft Access MVP "Kathy" wrote: I have a report with a subreport. I understand that when there are no records in the subreport then it will display empty. I read in another thread that you can put a control behind the subreport that will be visible when the subreport is empty. I am trying to do this with a control that ="No Records Found", but the control still shows up when the subreport has data. I tried the On Format suggestion, but did not work out. I am a novice, so it was probably my mistake...any further help is much appreciated. -- Kbelo |
#4
|
|||
|
|||
Subreport is empty...need to show "No Records Found"
Oops, just dawned on me...as had it in the wrong section. It is now
working...many thanks! -- Kbelo "Kathy" wrote: Thank you for your reply. I am still having problems...sorry, I am probably doing something "obvious", but just not to me. Anyway, this is what I am entering in an unbound textbox on the main form (not subform): =IIf(strStatus.Report.HasData, Null, "No Data") strStatus is on the subForm. But I am getting "#Name?" as the response. Again many thanks for your help. -- Kbelo "Duane Hookom" wrote: Set the control source to something like: =IIf(sbrptctrlName.Report.HasData,Null, "NO DATA") -- Duane Hookom Microsoft Access MVP "Kathy" wrote: I have a report with a subreport. I understand that when there are no records in the subreport then it will display empty. I read in another thread that you can put a control behind the subreport that will be visible when the subreport is empty. I am trying to do this with a control that ="No Records Found", but the control still shows up when the subreport has data. I tried the On Format suggestion, but did not work out. I am a novice, so it was probably my mistake...any further help is much appreciated. -- Kbelo |
Thread Tools | |
Display Modes | |
|
|