re-formatting date values in query design view

  • Thread starter Thread starter Matthew Dyer
  • Start date Start date
M

Matthew Dyer

I have a field titled ACTION_DATE that returns a general date value. I
want it to return a Short Date value instead. What do I put into the
Field to achieve this?
 
I have a field titled ACTION_DATE that returns a general date value. I
want it to return a Short Date value instead. What do I put into the
Field to achieve this?
Click to expand...

Simply set the Format property of the textbox on the Form or Report where
you'll be displaying the result. Query datasheets are not designed for data
interaction.

If you insist, you can rightclick the field in query design view and set its
Format property.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Simply set the Format property of the textbox on the Form or Report where
you'll be displaying the result. Query datasheets are not designed for data
interaction.

If you insist, you can rightclick the field in query design view and set its
Format property.
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com
Click to expand...

Since I have to link to the data tables i am unable to re-format them
that way.
 
Back
Top