Short date in Parameter query behind a report

  • Thread starter Thread starter Bill R via AccessMonster.com
  • Start date Start date
B

Bill R via AccessMonster.com

I have found that in date text boxes in a form, if I enter "9/25" and hit
enter, the box displays "9/25/2005". Similarly, when I enter "9/25" in the
criteria line of a query, it displays "#9/25/2005#".
However, when I run that same query, with the parameter "[Enter Date]" and
enter "9/25", the textbox on the report whose data source is "[Enter Date]"
displays "9/25", rather than "9/25/2005". Is there anyway to get the txtbox
to display the complete date?
 
I have found that in date text boxes in a form, if I enter "9/25" and hit
enter, the box displays "9/25/2005". Similarly, when I enter "9/25" in the
criteria line of a query, it displays "#9/25/2005#".
However, when I run that same query, with the parameter "[Enter Date]" and
enter "9/25", the textbox on the report whose data source is "[Enter Date]"
displays "9/25", rather than "9/25/2005". Is there anyway to get the txtbox
to display the complete date?
Click to expand...

Set its Control Source to

=CDate([Enter date])


John W. Vinson[MVP]
 
Thank you John! Once again to the rescue.

Bill

John said:
I have found that in date text boxes in a form, if I enter "9/25" and hit
enter, the box displays "9/25/2005". Similarly, when I enter "9/25" in the
Click to expand...
[quoted text clipped - 3 lines]
displays "9/25", rather than "9/25/2005". Is there anyway to get the txtbox
to display the complete date?
Click to expand...

Set its Control Source to

=CDate([Enter date])

John W. Vinson[MVP]
Click to expand...
 
Back
Top