Hello all:
Running Access 2003.
I have a form that collects optional information from the user, who then clicks the button and runs a report. For instance, the user enters "9/14/10" for the review date, leave the "reviewerName" field blank, and clicks the button to run the report.
The report has several expressions in text boxes. The first two are IIf statements that show data or not based on the optional information from the form. For instance, the "txt_ReviewerName"'s control source (textbox located in the Page Header):
I also have an expression in a group header that changes name based on the current group (txt_RToolGroup):
Finally, I have a text box in the Page Footer to calculate the current page (txt_PageNum):
These expressions generate with no errors when I run the report on screen. When I try to *print* the report, however, all the calculated fields print as "#ERROR". Someone please explain to me what is going on here and how I can correct this. Thanks!
Running Access 2003.
I have a form that collects optional information from the user, who then clicks the button and runs a report. For instance, the user enters "9/14/10" for the review date, leave the "reviewerName" field blank, and clicks the button to run the report.
The report has several expressions in text boxes. The first two are IIf statements that show data or not based on the optional information from the form. For instance, the "txt_ReviewerName"'s control source (textbox located in the Page Header):
Code:
=IIf(IsNull([reviewerName]),"__________________",[reviewerName])
I also have an expression in a group header that changes name based on the current group (txt_RToolGroup):
Code:
=[reviewToolNameLong] & " Review Tool"
Finally, I have a text box in the Page Footer to calculate the current page (txt_PageNum):
Code:
=IIf([Page] Mod 2<>1,[Page]/2,([Page]/2)+0.5)
These expressions generate with no errors when I run the report on screen. When I try to *print* the report, however, all the calculated fields print as "#ERROR". Someone please explain to me what is going on here and how I can correct this. Thanks!