Date stamp a memo field

[doran29]

i'm wondering if anyone has a solution to date stamp a memo field every time information is added.

e.g.

9/7 11:03 AM>1st sample information added 9/8 10:30 AM>2nd sample information added 9/9 2:34 PM>3rd sample information added

Any suggestions?
Thanks in advance,
Mark

 

[grnzbra]

I haven't tried this, but if I had to do it I would look into some code in the got focus and before update events of the text box.

In the got focus event, I would save the contents to a variable.

Then, in the before update event I would set my a string variable equal to

Right(Len(contentsoftextbox)-Len(contentsofvariable))

This should give you the newly addes stuff.

Then you would set string equal to

string = Now() & "> " & string

This would add the timestamp

Then set add the original stuff to the beginning

string = contentsofvariable & " " & string.

you might want to ad a carriage return and a couple of linefeeds in there.

then set the box equal to the string.

Don't know if this would work as described, but it's a starting point for playing.

 

[ghudson]

Why are you double posting? http://www.access-programmers.co.uk/forums/showthread.php?t=114113

 

[doran29]

it was a mistake....I hit submit twice

why are you so concerned with pointing this out?

 

[ghudson]

Then why don't you delete your duplicate post?