Hi
I have a form that start on open
i would like to show the current date in Day(text), date(number),
month(text), year(number)
i'e Monday, 7, December, 2009

i am trying to put this value in an unbound textbox


how do i format the date to display

thanks

kevin

On Dec 7, 4:17*am, kevcar40 <kevca... (AT) btinternet (DOT) com> wrote:
look at the FORMAT function's, second parameter
ie. format(date, "various patterns go here")

On Mon, 7 Dec 2009 03:17:02 -0800 (PST), kevcar40 wrote:

As the control source of an unbound control write:
=Date()
Then set the Format property of the control to
dddd, d, mmmm, yyyy

Are you sure you want all those commas in there?

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

"kevcar40" <kevcar40 (AT) btinternet (DOT) com> wrote

Kevin,

I have used the following VB code and created in an On Timer event I have a
label field named lblclock.

Private Sub Form_Timer()
Me!lblclock.Caption = Format(Now, "dddd, mmm d yyyy, hh:mm:ss AMPM")
End Sub

This display as shown here

Monday, Dec 21 2009, 02:40:37 PM

Hope this may be of some help.

Regards

Richard Cooke