locking field

laurat

Registered User.
Local time
Today, 16:55
Joined
Mar 21, 2002
Messages
120
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??
 
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
 
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.
 
Sorry, stupid question!

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

:P
 

Users who are viewing this thread

Back
Top Bottom