How to encode char13 with Microsoft Access?

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 20 points N/A #114247

How to encode char13 with Microsoft Access?

qa-featured

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)
Linefeed character

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:

=[Address]

& IIf([address2],Chr(13) & Chr(10) & [Address2])
& IIf([city],Chr(13) & Chr(10) & [City] & " " & [St] & " " & [zip])

Related Questions