Setting Field Size in a New Table

[vinfurnier]

Hi -

I'd like to know how to set the Field Size in a new Table. I need the user to be able to type in 17 characters (as in a vehicle VIN). I don't want the user to have the ability to type in anything less than 17 characters or anything more than 17 characters.

Thanx in advance,
vf

[alansidman]

In the properties for the field in your table. Set the length to 17.

In the input mask type & seventeen times. This will set the Access to only accept 17 characters for this field. No more -- no less.

It should like this in the field property &&&&&&&&&&&&&&&&&;;

[vinfurnier]

Thanx Alan.
I knew it had to be something simple,