help with #error in a field

[mrsbean]

The following code is present in a textbox in an Access form. I don't have the syntax right. Sometimes, the dMaxTimeStamp is null. When it is null, there is an error in the text box. What can I do to get rid of the error? I would like it to show a value or to leave it blank.

MrsBean

=IIf([dMaxTimeStamp]="#Error"," ",[dMaxTimeStamp])

 

[PHV]

Perhaps this ?
=Nz([dMaxTimeStamp], " ")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886