>I have a character field that is used to contain whether a member is a 'M'ale, 'F'emale
>or not answered (blank). I would like the field validation to call a stored procedure
>in the DBC to validate this value. If a user enters let's say a 'Q' then and I write
>my own MessageBox text and do a RETURN 0 then the fieldMessage follows.
>
>The field message allows a cancel and revert. The problem with Revert is that
>it reverts all entries on the line. Also a RETURN 0 causes a data type mismatch
>since the field validation expects a logical value.
>
>How can I use the stored procedure with my own MessageBox that does not
>fire the field message text?
Since you want to use your own stored proc to give the message, just do it, revert field in proc and return .t.
Cetin