re-formatting date values in query design view

[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?

 

[John W. Vinson]

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?

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

 

[Matthew Dyer]

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

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

 

[John W. Vinson]

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

Reread my message and try doing what I suggested... which had nothing to do
with reformatting the data tables.
--

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