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.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Pat" <(E-Mail Removed)> wrote in message
news:A2CAE10E-951D-40D3-9B01-(E-Mail Removed)...
> 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

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Pat" <(E-Mail Removed)> wrote in message
news:A2CAE10E-951D-40D3-9B01-(E-Mail Removed)...
> 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