Dates on Forms & Reports

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

Guest

I have a form that allows users to enter the date any way they want. I have a
report in which there is a field that shows whatever date was entered on the
form. No matter what way the date is entered on the form, I want the report
to show the date as Month Day, Year. For example, the date is entered like
this on the form: 8/1/2007 I want the report to show it like this: August
1, 2007.

How do I do that? I have already tried setting the format on the field in
the report, but no matter what I put it to, the date always shows up the way
it was entered on the form.

Thanks in advance for any help.
 
The Control Source for the text box should look something like:

=Format([Forms]![frmParameter]![txtParameter],"Long Date")
 
Back
Top