View Single Post
  #4  
Old May 25th, 2010, 06:41 PM posted to microsoft.public.access.forms
PJ
external usenet poster
 
Posts: 265
Default User Name in a text box

Thank Daryl, It worked can a date be added after the user name? If so, how
would that look.

Thanks again!!

"Daryl S" wrote:

PJ -

Use the On Enter method instead of the On Update method, and put in code
like this:

If isnull(Me!txtNotesOnTransaction) Then
Me!txtNotesOnTransaction = CurrentUser()
End If

--
Daryl S


"PJ" wrote:

I have the following code in a memo text field:

Private Sub txtNotesOnTransaction_BeforeUpdate(Cancel As Integer)
Debug.Print "User: " & CurrentUser() & " " & Me!txtNotesOnTransaction
End Sub

I want the current user entering data user name to fill in before typing any
other data.

It is not working any suggestions?

Thanks!!