<div>
what is the new line character: &nbsp;\r\n &nbsp;or\n?
</div>


<div>
Thanks capricorn, I was having a brain fart!!! &nbsp;Below accomplishes exactly what I want to do<br />
<br />
Private Sub JobComments_GotFocus()<br />
&nbsp; &nbsp; If Left(Me.JobComments, 1) &lt;&gt;&nbsp;vbCr And Left(Me.JobComments, 1) &lt;&gt;&nbsp;vbLf Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.JobComments.SelStart = 0<br />
&nbsp; &nbsp; &nbsp; &nbsp; SendKeys &quot;{Enter}&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; SendKeys &quot;{up}&quot;<br />
&nbsp; &nbsp; End If<br />
End Sub
</div>


<div>
<div class="content wysiwyg-content">
I have a memo field that hold comments about a record. &nbsp;They however like each new comment that is added to be at the beginning (top) not the end. &nbsp;What I would like to do is when the textbox gets the focus check and see if the first character is already a new line character, if not, I want to insert a new line character so when the user starts typing the text that is already there is moved down a line, and they are typing a new line at the top of the box. &nbsp;Make sense???
</div>
</div>


I have a memo field that hold comments about a record.  They however like each new comment that is added to be at the beginning (top) not the end.  What I would like to do is when the textbox gets the focus check and see if the first character is already a new line character, if not, I want to insert a new line character so when the user starts typing the text that is already there is moved down a line, and they are typing a new line at the top of the box.  Make sense???

what is the new line character:  \r\n  or\n?

Thanks capricorn, I was having a brain fart!!!  Below accomplishes exactly what I want to do

Private Sub JobComments_GotFocus()
    If Left(Me.JobComments, 1) &amp;lt;&amp;gt; vbCr And Left(Me.JobComments, 1) &amp;lt;&amp;gt; vbLf Then
        Me.JobComments.SelStart = 0
        SendKeys &amp;quot;{Enter}&amp;quot;
        SendKeys &amp;quot;{up}&amp;quot;
    End If
End Sub

Check if first character in text box (memo field) is a new line character

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

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.