Changing Field Sizes

[vvariety]

I have a database that has a field called carrier id and this field is used throught the program as it is a PK FK I need to change the length of the field from 3 to 4 is there a program out there that will allow me to globally change the field length for any table, form, report ? I tried Speed Ferret but it will only change the field name not the field property.

Thanks
Eileen

 

[maxmangion]

to change the length of your field simply go to the design view of your table, and in the field size property of your field, increment your length accordingly.