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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Simon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>

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, ...

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Simon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>