How to do vbCrLF in SQL
Posted on 2007-03-29
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.
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?