locking field

[laurat]

I have a notes field that different users will go into and continually add comments about one record. I have figured out how to get the cursor to appear after the previou comments that were entered. Is there a way for me to make the previous comments in the field unable to be edited??

 

[Fizzio]

Not directly as you can only lock the whole field, not a portion of it. Instead of adding to the same field, why not use an unbound textbox to enter new comments then add them via code to the (uneditable ie Locked=yes, enabled=no) comments field?

ie
txtCommentsAdd After_Update()
me.txtComments = me.txtComments & vbcrlf & me.txtCommentsAdd 'adds <CR> and new comments
Me.txtcommentsAdd = Null 'Clears add box
me.refresh 'refreshes the form

HTH

 

[danikuper]

Simple and efficient!!!

Is there a way I can add the new text before the existing one so the most recent is seen at the top?

thanks.

 

[danikuper]

Sorry, stupid question!

I just realized that all I need is invert the order in which the target field receives the new text.