#ERROR Message

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

Guest

I have code in a report text box that works great.
Just one problem, If the field or fields is missing or doesn't have data the
function will display and annoying "#Error" message. How can I just display a
blank or "N/A" Message instead. Thanks all

diff2dates("hn",CDate([rec Dte] & " " & [rec time]),CDate(Date() & " " &
Time()))
 
Test to see if the field or fields is null

IIF(IsNull([Rec Dte]),"N/A", diff2dates("hn",CDate([rec Dte] & " " & [rec
time]),CDate(Date() & " " & Time())))

If you need to check both then
IIF(IsNull([Rec Dte]) or IsNull([rec time]), ...,...)
 
This works fine if Rec dte or Rec dte are blank, but #Error appears if no
records meet the query. How do I control the message when no records are
found for this query in the report? Thanks for your help Mr. Spencer

John Spencer said:
Test to see if the field or fields is null

IIF(IsNull([Rec Dte]),"N/A", diff2dates("hn",CDate([rec Dte] & " " & [rec
time]),CDate(Date() & " " & Time())))

If you need to check both then
IIF(IsNull([Rec Dte]) or IsNull([rec time]), ...,...)

bladelock said:
I have code in a report text box that works great.
Just one problem, If the field or fields is missing or doesn't have data
the
function will display and annoying "#Error" message. How can I just
display a
blank or "N/A" Message instead. Thanks all

diff2dates("hn",CDate([rec Dte] & " " & [rec time]),CDate(Date() & " " &
Time()))
Click to expand...
Click to expand...
 
Back
Top