Solved

How to do vbCrLF in SQL

Posted on 2007-03-29
2
6,342 Views
Last Modified: 2009-02-18
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?
0
Comment
Question by:snyperj
2 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 18815822
use use CHAR(10) & CHAR(13)
0
 
LVL 26

Accepted Solution

by:
jerryb30 earned 500 total points
ID: 18817009
chr(13) & chr(10), actually, in access
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now