Is there a shortcus keystroke to add the current date to a text bo

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

Guest

Hello;

I am using Access 2002 with XP.

In Excel you can add the current date into a cell by typing Control semi
colon. Is there a similar (easy) way to add the current date info an Access
form text box?

Thanks for your help - have a great week!
 
Brendan;

Thanks for your quick response. I am trouble getting this to work. The
date field in my table is set to date/time. When I try to enter the date in
the form text box by using Control semi-colon the 2 slashes appear to
separate the day, month and year but the date numbers do not populate. I
also changed the data type in the table to text and the same thing happens.
I am doing something wrong?

Thanks again - have a great day!
 
I'm afraid I've never seen anything like that, Bill. My guess is that it is
probably some kind of display glitch - that the digits are there, but for
some reason not visible. You could test that if you like by placing some
code in the Change event of the text box to print the Text property to the
Immediate window ...

Private Sub Text0_Change()
Debug.Print Me.Text0.Text
End Sub
 
Back
Top