>>I had this done in fp2.6 but I have to bring this over to VFP.
>
>You can also write the validation in the field rule of the view or table so you don't have to duplicate it in every UI...
>
>Jim has a great method to do this... that I adopted a bit... do the validation in the view and table rule, if the rule is called from a view always return .t. so the user doesn't have to stop heads down entry, but returning a false if it comes from the table so it can't be saved.
>
>I modified this abit by changing the background of the activecontrol to red if the value was bad... this would give the user a visual cue of the bad field prior to a save.
>
>BOb
Thanks.
That sounds pretty interesting? I never thought to put that type of validation in the dbc? I'll get to it today or tomorrow. The module is not due till Aug first.