Dates Format from Code

[charly.csh]

Hello all,



Do you now how change the format of the dates from code?

I have a textbox called "Datetxt" and when the form is load, it automatically load the date today, however I would like to show date and time

How can I do this?

Private Sub Form_Load()
On Error GoTo err_trap
GetDomains
Exit Sub

Me.Datetxt = Date



err_trap:
MsgBox ("Error: " & Err.Number & vbCrLf & Err.Description)
Exit Sub


End Sub




Thanks in advance for the help!!!!

[June7]

Use Now() instead of Date() to capture full date and time value.

Is the textbox Format property set to allow display of time parts? Don't set any formatting and the full value will display.

[ItsMe]

Without any formatting, you can get the current date and time using
Me.Datetxt = Now

The easiest way to format would be to use the properties of the textbox control named Datetxt. I would use the Property Sheet in Design View of your form to format the textbox.

[charly.csh]

Thank you
it's correct!!!

[charly.csh]

Thank you it also works!!!