displaying the Day from a date

[Simon]

I have a field on my form that displays a date like 2nd April 2007 is
there a way to display the day as well

eg
Monday 2nd April 2007


Thanks very much


SImon

 

[Allen Browne]

Set the Format property of the text box to:
Long Date

That should show the day and date (depending on how you have Long Date
defined in the Windows Control Panel, under Regional Settings.)

You can also show the day in another text box with the Format property set
to:
dddd

 

[Douglas J. Steele]

How are you getting 2nd April 2007? AFAIK, Access doesn't have any built-in
way to display the ordinal portion of the date (the "nd" in this case). If
you're using a function to provide that for you, modify the function to pick
up the day name using Format(YourDateValue, "dddd"). Format(YourDateValue,
"ddd") will return Mon, Tue, Wed, ...