How to use this in Access:
The above numbers are usually put in Chr$(xx)
So
& Chr$(13) ' would add a Carriage return to a line.
Example of how to add a carriage return, line feed to a message box:
-------------------------------------------------------
Dim MyString As String
MyString = "this is Line 1" & Chr$(13) & Chr$(10)
MyString = MyString & "This would be line2" & Chr$(13) & Chr$(10)
MyString = MyString & "And this is line3"
sometimes itÆs necessary to add single quotes to a SQL statement
Dim MySQL As String
MySQL = "Select * From MyTable Where MyField = " & Chr$(39) & SomeVariable & Chr$(39)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.