field works on preview but ?Name Error on print

  • Thread starter Kathy - Lovullo
  • Start date
K

Kathy - Lovullo

I'm looking for some help on a printing problem.

I have a calculated "IIF" field that prints different reports dates in the
Page Header of my report. When I preview the report on screen, I see the
field working properly on screen.

However, when I send the report to the printer, it prints "#Name?".

Does anyone have any ideas on what may be causing this?

Thanks!
 
D

Duane Hookom

Maybe you could share the Control Source property rather than just stating
"calculated IIf field"...
 
K

Kathy - Lovullo

Sorry. Here is the Control Source for my date field. The field shows
properly when previewing the document, but does not print.

="Report Date: " & IIf(IsNull([Forms]![frmWhatDates]![txtStartDate]) And
IsNull([Forms]![frmWhatDates]![txtEndDate]),(DateSerial(Year(Date()),Month(Date()),1))
& " And " & Date(),[Forms]![frmWhatDates]![txtStartDate] & " - " &
[Forms]![frmWhatDates]![txtEndDate])

Thanks!
 
D

Duane Hookom

Are you closing the form with code in your report?

--
Duane Hookom
MS Access MVP


Kathy - Lovullo said:
Sorry. Here is the Control Source for my date field. The field shows
properly when previewing the document, but does not print.

="Report Date: " & IIf(IsNull([Forms]![frmWhatDates]![txtStartDate]) And
IsNull([Forms]![frmWhatDates]![txtEndDate]),(DateSerial(Year(Date()),Month(Date()),1))
& " And " & Date(),[Forms]![frmWhatDates]![txtStartDate] & " - " &
[Forms]![frmWhatDates]![txtEndDate])

Thanks!

Duane Hookom said:
Maybe you could share the Control Source property rather than just
stating
"calculated IIf field"...

--
Duane Hookom
MS Access MVP


message
Click to expand...
Click to expand...
 
K

Kathy - Lovullo

Thank you. This worked. After I stopped closing the form, the report now
prints properly.

Duane Hookom said:
Are you closing the form with code in your report?

--
Duane Hookom
MS Access MVP


Kathy - Lovullo said:
Sorry. Here is the Control Source for my date field. The field shows
properly when previewing the document, but does not print.

="Report Date: " & IIf(IsNull([Forms]![frmWhatDates]![txtStartDate]) And
IsNull([Forms]![frmWhatDates]![txtEndDate]),(DateSerial(Year(Date()),Month(Date()),1))
& " And " & Date(),[Forms]![frmWhatDates]![txtStartDate] & " - " &
[Forms]![frmWhatDates]![txtEndDate])

Thanks!

Duane Hookom said:
Maybe you could share the Control Source property rather than just
stating
"calculated IIf field"...

--
Duane Hookom
MS Access MVP


message
I'm looking for some help on a printing problem.

I have a calculated "IIF" field that prints different reports dates in
the
Page Header of my report. When I preview the report on screen, I see
the
field working properly on screen.

However, when I send the report to the printer, it prints "#Name?".

Does anyone have any ideas on what may be causing this?

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Top