Date doesn't appear automatically when running date code

Private Sub txttodaysdate_change()

txttodaysdate = Format(Now, "mmm/d/yy")

End Sub

when i use this code i wnat the date to automatically appear in the text box but it doesn't I have type something into the textbox then the current date appears, any help would be great.

Hi James,

Notice the "txttodaysdate_change()" bit. That means the code will only run when you make a change to that textbox.

If you want it to update for some other reason or when some other event happens, let us know the details..

Ah, to get it to happen when the form opens, you have to reference the Forms "Initialize" event, like so:

Please Login or Register  to view this content.