Changing field data type - Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.)
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Type Conversion Error While Importing (Time Field) 8
"Can't change data type" error - Access 2003 6
Field Data Type for Linked Tables 8
Can't change data type 2
Record-Locking remains open after closing 0
MS Access cant change the data type ; there is not enough disk space or memory. 4
Why do I receive an error when trying to change a data type? 3
Data Type Issue in Linked Excel Table 7

Back
Top