- Local time
- Today, 15:12
- Joined
- Sep 12, 2006
- Messages
- 15,653
That makes sense. If you do not need to manage the separate comments (sort, filter, etc) you can do a running log in one field. I usually have a button to add the date to the comments to facilitate that.
Code:Private Sub cmdDate_Click() Dim strDate As String Dim SomeTextBox As Control Set SomeTextBox = Me.txtSomeTextBox_Comments strDate = Format(Date, "yyyymmdd") & "-" If Trim(SomeTextBox & " ") = "" Then SomeTextBox = strDate Else SomeTextBox = SomeTextBox & vbCrLf & strDate End If SomeTextBox.SetFocus SomeTextBox.SelStart = Len(SomeTextBox) + 1 End Sub
Then my running comments look like
20180904 - Some long comment here
20180905 - Some more comment
....
Yes, that's what I meant. I generally add the date and user who added the added the comment, and the comment.