G
Guest
I can not find where to go to get to data type to change field from date to
text. Please help.
text. Please help.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
You would open the table in design view and change the field type, but a
date is stored in the table as a number. If you change it to a text field
you will end up with a pretty much meaningless field.
If you want to display a date in a different FORMAT, then you can do so in
your forms, queries, and reports. For example...
=Format([SomeDateField],"medium date")
or
=Format([SomeDateField],"long date")
date is stored in the table as a number. If you change it to a text field
you will end up with a pretty much meaningless field.
If you want to display a date in a different FORMAT, then you can do so in
your forms, queries, and reports. For example...
=Format([SomeDateField],"medium date")
or
=Format([SomeDateField],"long date")