N/APosted on - 01/05/2012
Hi there! I want to know how to use char13 in Microsoft Access 97 but I don’t know how it was encode. At first, I thought it was written as “chr(13)” but it won’t work. So, does anyone here know how to write it correctly in Access 97? And also, kindly include a working code as an example. Any form of help would be deeply appreciated.
How to encode char13 with Microsoft Access?
Chr(13) means carriage return. What it does is to move the cursor to the leftmost side of the string. It is usually paired with chr(10) to get the desired result. When you use it alone, it won’t no result.
Please see sample code below:
Extract from Help: Access97
vbCrLf = Chr(13) + Chr(10)
Carriage return�linefeed combination
vbCr = Chr(13)
Carriage return character
vbLf = Chr(10)
vbNewLine= Chr(13) + Chr(10) or Chr(13)
Platform-specific new line character; whichever is appropriate for current platform
Another set of sample codes using to get an expandable block:
& IIf([address2],Chr(13) & Chr(10) & [Address2])
& IIf([city],Chr(13) & Chr(10) & [City] & " " & [St] & " " & [zip])