<div>
Generally, I think it is bad practice to add new comments to a comment field.<br />
<br />
I prefer to have a separate table for the comments, so that each comment is a single record, which can be displayed in a continuous subform. &nbsp;With this technique, you have the added option of being able to prevent the users from changing previous comments, to preserve a comment history.
</div>


Generally, I think it is bad practice to add new comments to a comment field.

I prefer to have a separate table for the comments, so that each comment is a single record, which can be displayed in a continuous subform.  With this technique, you have the added option of being able to prevent the users from changing previous comments, to preserve a comment history.

<div>
Jeff. &nbsp;Thanks. &nbsp;That did it.<br />
<br />
Dale, I agree and normally do it that way. &nbsp;But in this case the &quot;simple&quot; method will be just fine.
</div>


Jeff.  Thanks.  That did it.

Dale, I agree and normally do it that way.  But in this case the "simple" method will be just fine.

<div>
<div class="content wysiwyg-content">
I am using the following code to add a comment to a text field. &nbsp;But I want the now comment to be at the beginning of the field. &nbsp;Is there a way to force a [Home] key so the new comment is at the beginning?<br />
<br />
Me.txtComments = Me.txtComments &amp;&nbsp;vbCrLf &amp;&nbsp;Me.txtNewComment &amp;&nbsp;vbCrLf &amp;&nbsp;DLookup(&quot;[CurrentUser]&quot;, &quot;LOCALtblCurrentUser&quot;) &amp;&nbsp;&quot; &quot;&nbsp;&amp; Now() &amp;&nbsp;vbCrLf
</div>
</div>


I am using the following code to add a comment to a text field.  But I want the now comment to be at the beginning of the field.  Is there a way to force a [Home] key so the new comment is at the beginning?

Me.txtComments = Me.txtComments & vbCrLf & Me.txtNewComment & vbCrLf & DLookup("[CurrentUser]", "LOCALtblCurrentUser") & " " & Now() & vbCrLf

How get to the beginning of a text field via code

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.