Hide "#Errror" Field Message?

[10 Gauge]

Is there a way to hide the "#Error" message displayed in computational fields for new records?

[TheShabz]

I dont believe so. Further, except for the rare occasion, you shouldn't be holding calculated fiends in a table to begin with.

[10 Gauge]

I don't have any calculated fields held in the table, they are all held in unbound text boxes on the form only.

Thanks though, they will just have to deal with #Error.

[TheShabz]

Oh. You said "field" and it threw me off. I thought you were referring to a table. You can use the Nz() function to default to something that wont error out.

[10 Gauge]

Thanks Shabz, didn't even think of that!