Formatting query parameters in a report

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi,

This question is further to the post "Resusing query
parameters in a report" at 7:25 a.m. today (23rd) and the
response, which, by the way, told me exactly what I needed
to know about that subject!

I have the control source of my unbound text box set to my
parameter and I have the unbound text box formatted to a
long date. It appears that the long date format is being
ignored. The report instead displays the start date
exactly the way the user types it in.

Is there some way to force the report to display the long
date format without forcing the user to enter dates in the
long date format?

Thanks for any and all help!
 
Something like:

="Between " & Format([Enter Start Date],"Long Date") & " And " &
Format([Enter End Date],"Long Date")

The text within the brackets must, of course, be identical to the query
bracketed criteria text.
 
Back
Top