How to encode char13 with Microsoft Access?

Asked By Sachi Yu 0 points N/A Posted 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.

• Status: Open
• Question Views: 1100
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Aristono Martin 20 points N/A #114247

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

About Aristono Martin

Questions
3

Answers
370

Best Answers
53

• Vote Up 0 Vote Down

• Posted on - 01/06/2012
• Question Category: MS Access