Date in text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Currently, I'm created a form with this field, "Updated by".

If I wld like today's date to appear in the textbox,"updated by" How do I go
abt doing it???

Thank you for all the help!!!!
 
Use the BeforeUpdate event procedure of the form to put the date in the
field:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[Updated By] = Date
End Sub

Use Now() instead of Date if you want the time as well as the date.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing Date Stamp on Form 6
Access 2 Digit year in Access Text Box 3
Excel Message box with days of month & date. 1
Hello happy new year to all, Text box input for year of purchase 0
Setting field value if a value exists in another table 3
creating text box dynamically in ms access 2
problem getting a value from Date() 11
Problem: textbox default value = Date() 3

Back
Top