Add New Text in a Text Box without allowing any modification of existing text.

[lmarconi]

Good afternoon everyone.


Having a form bounded Text Box where some text might be already present, I was looking a way to allow to add new text but not allow to change what has been already saved in the same field. Is like to freeze what has been already previously saved.
Is someone so kind to give me a suggestion?
Thank you,

[ranman256]

txtBox = txtbox & vbcrLf & txtNewTxt2Add

[Gicu]

If it is for some sort of chronological notes or comments I strongly suggest you replace it with a subform bound to a new table that stores the record id, comment,(DateCreated,CreatedBy).Much easier to deal with than a huge memo field.

Cheers,

[lmarconi]

Thank you for kindly suggestions.
Considering the scope is exactly to keep history of some comments where is good to have a date, I followed the options suggested by Gicu.
Just another quick question please: having three fields in the new bound subform (ID, ID_DATE and COMMENT), how i can order the view of record by ID_DATE decrescent ? just to have the last comments in the top of the form.
Thank you again.
L.

[lmarconi]

Thank you for kindly suggestions.
Considering the scope is exactly to keep history of some comments where is good to have a date, I followed the options suggested by Gicu.
Just another quick question please: having three fields in the new bound subform (ID, ID_DATE and COMMENT), how i can order the view of record by ID_DATE decrescent ? just to have the last comments in the top of the form.
Thank you again.
L.

I solved with COMMENT_DATE DESC in the the sub form "ORDERBY" properties.
Thank you anyway.

[Gicu]

Glad to hear you solved it Alternatively you could create a query based on your table "SELECT ID, ID_DATE, COMMENT FROM tblComment Order By ID_DATE DESC;" and used that as the record source of the subform.

Cheers,
Vlad