No of visitors who read this post: 452
Category: MS Access
Type: Question
Author: Sachi Yu
No votes yet

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.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

# Comment Id: 43808

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])