From: Twb on 29 Apr 2010 05:25
"John W. Vinson" wrote:
> On Tue, 27 Apr 2010 08:32:03 -0700, Twb <Twb(a)discussions.microsoft.com> wrote:
> >I would like to show the day of the week based of the date e.g. 27th April
> >2010 - Tuesday, is this possible? please help.
> >Many thanks
> Sure. You can use a Format for the date including the day name. For instance
> you can use a textbox on a form with a control source
> or bound to a date/time field in your table. To get almost the exact
> appearance you describe (without the 'th' which will take some VBA code) set
> the textbox's Format property to
> "dd mmmm yyyy \- dddd"
> The dd format option gives the numeric day; ddd gives the three letter day
> abbreviation (Tue), dddd the full day name (Tuesday).
> I'm pretty sure you can find some code for the ordinal numbers (1st, 2nd,
> etc.) at http://www.mvps.org/access - search for "ordinal".
> John W. Vinson [MVP]