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!