How to limit the size of a text field

[Normand]

I need to limit the number of characters that can be entered in some of my text fields in a table (ex: ClientCode: 10 char, ClientName: 50 char, ZipCode: 6 characters, etc). I just don't seem to find the place where I can do this in FM.

Coming from a MS Access/classic DB development environment, I find it really strange that nowhere you define the length of your text fields when setting up a table in FM. Or am I not looking properly ?

Thanks

Edited October 4, 2006 by Guest

[Fei]

Under define fields > validation > and tick maximum no. of chars.