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.

 

[Pat Hartman]

Yet another reason to use autonumbers as keys rather than text fields. Choosing fields which have the potential to change format causes lots of work if the format has to change. Allowing value changes is bad enough but doesn't cause any extra work as long as your relationships are properly defined and have specified cascade update.

You'll need to remove the relationships, make all the field changes, and then reestablish the relationships.