Null value for date/time field as "Off"

[esu4edp]

I have a report that has a time field. If that value is not filled in or left blank, I want that value to be displayed at "Off" on the report. I have tried several statements but they dont work:

Nz([Arrive],"Off")

SELECT IIF(IsNull([Arrive]), 'OFF, [Arrive])

=IIF([Arrive] Is Null,OFF,[Arrive])

none of these have worked or have given errors.

 

[RoyVidar]

Did you try entering the following into the format property of the control on the report in stead?

[tt]hh:nn:ss;;"Off";"Off"[/tt]

Roy-Vidar

 

[stix4t2]

If this is a control source then you have to set the equal sign. Also the "OFF" must be in quotes. Lastly if the textbox name is Arrive then you can't have a field with the same name, you might change it to fldArrive.

=IIF([Arrive] Is Null,"OFF",[Arrive])

 

[esu4edp]

hh:nn:ss;;"Off";"Off"

This worked out great exept for times that started at midnight or 00:00

the other example =IIF([Arrive] Is Null,"OFF",[Arrive])

keeps giving me an error

 

[BoxHead]

how about trying

= IIf(IsNull([Arrive]),"OFF",[Arrive])

or

=IIf(nz([Arrive],"")="","OFF",[Arrive])


HTH


John





When Galileo theorized that Aristotle's view of the Universe contained errors, he was labeled a fool.
It wasn't until he proved it that he was called dangerous.

 

[RoyVidar]

[tt]hh:nn:ss;;;"Off"[/tt]

Roy-Vidar

 

[esu4edp]

hh:nn:ss;;;"Off"

This worked perfect!

Thanks