formatting a date from dd/mm/yy 1

[paulminne]

Hi,

I have a field in a report which is copied from a textbox on another form. However, it is being formatted as dd/mm/yy even though I have set the 'format' property of the text box to 'long date'.

Is there a way to format this field to long date (eg Sunday, 17 March 2003) ???

Regards,

- Paul

 

[ajdesalvo]

Use this in the report's text box control source:

=Format(Forms![YourForm]![DateField], "dddd dd"", ""mmmm yyyy&quot


Good luck! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[sathandle]

Check your options.

Access 2000:
(Tools, options, General Tab, lower right hand corner, Use four-digit year formatting, this database/all databases)

Hope this helps.
SATHandle
definition of 'less behind': "not fully caught up, digging out slowly, one-week delay to "The IT hit the fan."