>>Given this, client.name, what would be the simpliest way to get the field lenght of "name" field.
>
>Is
>
>FSIZE(cFieldName [, nWorkArea | cTableAlias] | cFileName)
>
>that you are talking about?

That is ok.

Now, I need something similar for the type of the field and the number of decimals for numeric field.

I want to modify my base textbox control to be able to set the input mask automatically.