#Num!

[Guest]

Is there a formula that i can use that will just null the field if access
encounters this error? Would save me having to manually adjust all data. I
am wits end so have decided that if they give me bad data it will not go into
the data base - they will just have to live with it or submit data in the
proper format.

 

[Guest]

Depends on the problem. If it's with nulls, you can use the NZ function.

If it's none-numerical characters in a number field:

IIf(IsNumeric([TheField]) = True, [TheField], Null)

Jerry Whittle