Button not working as expected

[hpl2001]

I have a button on my form that I want to enter some text into a text box field when I press it. The data is stored in a memo field in the table. The code behind the button looks like this:

Me.txtTrackingInfo = "Retrieved: " + Format(Now, "yyyy-mm-dd") + " " + Environ("Username") + vbNewLine + Me.txtTrackingInfo

The first time I press the button no text is put into the field, but every subsequent time I press it the text is entered as expected.

What might cause this?

TIA.

Holly

 

[dhookom]

Why are you using "+" rather than "&"? I would try:

Me.txtTrackingInfo = "Retrieved: " & Format(Now, "yyyy-mm-dd") & " " & Environ("Username") & vbNewLine & Me.txtTrackingInfo

Duane
Hook'D on Access
MS Access MVP