Where to find the Data Type to change a field to text

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

Guest

I can not find where to go to get to data type to change field from date to
text. Please help.
 
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")
 
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

Access Form - Lock Fields from Editing 0
Importing Text Files Into Access 1
Access Access - Is it possible to repeat fields in a form? 1
How to subtract a number from a Mergefield? 0
Excel Typed text appears in wrong cell 0
#Type! error on form 6
type mismatch in a form 3
Split Form event "On Data Change" 3

Back
Top