field works on preview but ?Name Error on print

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Maybe you could share the Control Source property rather than just stating
"calculated IIf field"...
 
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!
 
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...
 
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...
 
Back
Top