Is there a way to hide the "#Error" message displayed in computational fields for new records?
Is there a way to hide the "#Error" message displayed in computational fields for new records?
I dont believe so. Further, except for the rare occasion, you shouldn't be holding calculated fiends in a table to begin with.
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.
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.
Thanks Shabz, didn't even think of that!