Memo field with many entries

[Birdman895]

Not sure if this makes sense, (I'd rather not create a comments table)
A user enters text into a memo field for an existing client, then it's closed, the same record reopened and more entered into the memo.
The problem is when it's reopened the existing text is hi-lighted, and it's really easy for someone to begin typing and write over it.
I want to reopen it, create a new line, enter a date stamp maybe, create another line with the cursor in it, ready for the user to enter new text.
Any thoughts?

 

[pbaldy]

I don't personally like that structure, but it's your baby. You can look at SelStart to control the cursor, or provide the user a separate textbox to enter their new text, and you append it to the actual field behind the scenes. The second would be more bulletproof, not allowing the user to edit previous data, just add new (you could obviously provide an interface to allow full editing if you wanted).

 

[vbaInet]

My preference is to have a Comments table, it makes sense in many ways. However, having a comments table or not doesn't really affect your current dilemma.

I like the idea of using a separate textbox for entering new comments (like pbaldy suggested) and a second wider and taller textbox/section for displaying related comments.

 

[Birdman895]

I like the second way too.
I've created a new textbox in my form and in the On-enter event I have it writing the Date, Username, and a vbcrlf into it, and then using SelSart to position the cursor. After the user enters their text I'll probably use a button to append.
What is the simplest & safest method to append the text from there into my original memo field?

 

[pbaldy]

Presuming the original field is on the form:

Me.OriginalField = Me.OriginalField & Me.NewStuff

 

[Birdman895]

well I asked for simple. I thought it would be far more complicated for some reason

 

[pbaldy]

We can do something more complicated if you want.