Date
 

hi

I have a textbox with which i use the "= date" to display the date init when
clicking on cmd1 button.
the date is displayed as mm/dd/yy...
i want it to be displayed as yyyy/mm/dd

how do i activate the numberformat property or can sum1 please direct me

Regards!

Date
 

It is unclear how you are populating your textbox or what type of textbox it
is.

Possibly

Private Sub Commandbutton1_Click()
me.Textbox1.Value = format(date,"yyyy/mm/dd")
End sub

--
Regards,
Tom Ogilvy


"Zaahir" wrote:

hi

I have a textbox with which i use the "= date" to display the date init when
clicking on cmd1 button.
the date is displayed as mm/dd/yy...
i want it to be displayed as yyyy/mm/dd

how do i activate the numberformat property or can sum1 please direct me

Regards!