How do I replace #Error with somehting else

Dear all,

I am getting #Error on one of the form on my Access form, I know the reason, but i can't force the user to do something that I want, and I am getting #Error, I just want to replace it with something else, how do I do that?

PlayKid

Can't you just error trap it with an On Error Goto?

Oh....sorry, my mistake, not on VBA, but on the actual Access form, I am using an argument something like this:

=IIf(IsError(Date = ""), "Insufficient Information")