Differences between field and control

sridhar

When we have to code in Onvalidate() of a control (Textbox)and when we have to code in Onvalidate() of field?

N.Sridhar

charlp

I prefer to use the OnValidate at field level on the table, otherwise you will have to duplicate your validation code on each form you might create that makes use of the table.

kine

On form only if you need some specific checking which is specific for the form... else on table...

DenSter

There is one simple rule you should follow:
Data operations should always be programmed in the table.
Display operations should always be programmed on the form.

So if you need to change a color depending on the value of a field, you do it on the form. If you need to default address information depending on the customer number, you do it in the table.