data appears in Layout View but not in Print Preview?

K

KLR

I have a report with 4 subreports. Each subreport is linked by the ClientID.
When there is no data in one of the subreports it is left blank. I have an
unbound control with the following control source: =IIf([HasData]=0,"No
Investors","") in the Client ID Header of the subreport.

The message prints in the correct subreport on the Main report, but only in
Layout View, not in Print Preview and/or when I print. How can I correct
this?

Thank you.
 
J

June7 via AccessMonster.com

The reference to HasData in the control (textbox?) may be treated as a field
name (although think you would get parameter prompt). Try prefixing it with
the form name and even then may not be able to access that form property from
a control and instead must be in code. I have tried to access form OpenArgs
property from a control and couldn't. Had to use a function to extract it and
the function was called in textbox.
Check out this MS link:
http://msdn.microsoft.com/en-us/library/aa195920(office.11).aspx
I have a report with 4 subreports. Each subreport is linked by the ClientID.
When there is no data in one of the subreports it is left blank. I have an
unbound control with the following control source: =IIf([HasData]=0,"No
Investors","") in the Client ID Header of the subreport.

The message prints in the correct subreport on the Main report, but only in
Layout View, not in Print Preview and/or when I print. How can I correct
this?

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top