Dates on Forms & Reports

[trainsteve]

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.

 

[Roger Carlson]

Is it stored in a date/time field or a text field. If text, formatting
won't affect it. It should be stored in a date/time field.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Jerry Whittle]

The Control Source for the text box should look something like:

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