>Lets try this again. BTW, never check Rules of conduct after typing a long message, before sending it.
>
>I have a major problem with field and record rules. I may be overlooking something very basic however Microsoft posts 'work-arounds' on the knowledgebase so I think I'm on the right track. It seems that I (at least me) can't put up my own dialog (not Ok, Revert, Help) and fix the data problem without getting into a tailspin of errors (Invalid data type for example).
>
>If anyone would be interested in discussing their experience with the DBC field and record rules I would be very interested. And, as I am working on an end month deliverable, very appreciative.
>
>Thanks
Stephen,
A failed rule is an error and it generates an error condition. If you have an error handler you can trap for the error and give your own message. I wouldn,t change (fix) the error, I would change the value of the control to a vlaid value and make the user confirm the change.