Changing field data type - Access 2003

P

Pat

If I change the data type of a field in an already existing table, will that
cause any problems? I would like use design view to change the data type
from number to text.

Thanks,
Pat
 
A

Allen Browne

Changing from Number to Text should work fine (unless you were to set the
Field Size too small to handle the number of digits you need.)
 
D

Douglas J. Steele

If the field isn't part of a relationship, then you shouldn't have any
issues. (Access won't let you change the data type if it is part of a
relationship: you'll need to delete the relationship first).

Of course, if you've got code using that field, you could run into issues.
 
Top