Null's and Access via DAO

Is it possible that null values in fields of an Access database could cause an error 3426 'Update cancelled by associated object' or is it more likely that VB 6 just gets really confused when I change the order around on the maskedbox's. If I mark a record for edit and make any changes to the fields in that record I will get the above mentioned error as soon as I try to save the updated record.

I'm beating my head against the wall (and a deadline) on this one. I have tried recreating the form and also eliminated all other tables except the one really essential one. Nothing seems to eliminate the problem.

The whole database was imported to Access from a Foxpro 2.x system and it is riddled with null values.

Any suggestions would be greatly! appreciated.
Thanks
DonB

[Wesam]

Probably the NULL values are the problem, try putting a blank string instead of NULL value.

Dim RecVal as String

If RecVal = NULL Then RecVal = RecVal & ""

Wesam

------------------

[Wesam]

Probably the NULL values are the problem, try putting a blank string instead of NULL

Dim RecVal As String

If RecVal = NULL Then RecVal = RecVal & ""

Wesam

------------------