Prev: Auto generating primary key number
Next: Switchboard Label1 Missing
From: Twb on 29 Apr 2010 05:25
Thanks

"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
>
> =Date()
>
> 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]
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Auto generating primary key number
Next: Switchboard Label1 Missing