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
Printable View
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")