<div>
<div class="content wysiwyg-content">
We have a memo field that serves as a scratchboard-type of notes field. &nbsp;Several command buttons allow users to enter common phrases to the memo field by just clicking on them.<br />
Example:<br />
Me.reqnotes_memo = Me.reqnotes_memo &amp;&nbsp;&quot; &nbsp;&quot; &amp;&nbsp;vbCrLf &amp;&nbsp;date &amp;&nbsp;&quot;(&quot; &amp;&nbsp;Me.txtinit &amp;&nbsp;&quot;)-&quot; &amp;&nbsp;&quot; Waiting on programming. &quot;<br />
<br />
The design is terrible, but for what it is used for- it serves a purpose. &nbsp;Having said that, here is my question:<br />
<br />
I need to have a user add data to reqnotes_memo field in this table from a screen other than the one mentioned above. &nbsp;So his data will be appended using an update query. &nbsp;I know how to do that with the exception of the vbCrLf. &nbsp;How can I do a carriage return in SQL?
</div>
</div>


We have a memo field that serves as a scratchboard-type of notes field.  Several command buttons allow users to enter common phrases to the memo field by just clicking on them.
Example:
Me.reqnotes_memo = Me.reqnotes_memo & "  " & vbCrLf & date & "(" & Me.txtinit & ")-" & " Waiting on programming. "

The design is terrible, but for what it is used for- it serves a purpose.  Having said that, here is my question:

I need to have a user add data to reqnotes_memo field in this table from a screen other than the one mentioned above.  So his data will be appended using an update query.  I know how to do that with the exception of the vbCrLf.  How can I do a carriage return in SQL?

How to do vbCrLF in SQL

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.