Access 2007 - Event help

5ingh · 15 Dec 2008 at 14:29

I've added an OnClick event that adds the current date and time to a textbox, but, when the time gets added, it deletes everything that is already in the textbox. Is there a way to stop this, so that it just adds on to what is already in the textbox? i.e.

"hello there whats up
date/time
more stuff
date time
"

Here's the code:

Code:

Private Sub Notes_Click()
    Me.Notes = Now()
End Sub

Thanks!

5ingh · 15 Dec 2008 at 14:45

Thanks J

That is working better but it overwrites any normal text that I add to the textbox.

5ingh · 15 Dec 2008 at 15:04

In the above text box, I entered "hello", followed by the date/time event. However, "hello" text got replaced by the date/time. I deleted everything and tried again a few times, but now it gives me the above whenever I use the event.

So basically, it doesn't like sharing the date/time with normal text together.

Thanks

Edit:

I deleted the data from the 'notes' field in the table instead and then tried again:

That looks ok. But If I enter some text after the above time, followed by the time again, the newer text gets replaced. When I delete everything from the textbox, I get the same thing happening as the 1st pic again but with "test time time time time time time time" instead. Hope you understand, its kind of hard to explain!

5ingh · 15 Dec 2008 at 15:45

Thanks J, I think I understand what you mean. I'll try it out later.

Thanks