Menu
A simple question, doing my head in...
I have a large access database to clean up.
Is there a system constant for a line break in Access (Like VB's VBCrLf)?
If not,I guess I'll just have to use Chr(13) + Chr(10)
684
In the Find box hold down the Alt key and type 0 1 0 for the line feed and Alt 0 1 3 for the carriage return. They can now be replaced with whatever you want.
In Windows, a new line is denoted using “\r\n”, sometimes called a Carriage Return and Line Feed, or CRLF. Adding a new line in Java is as simple as including “\n” , “\r”, or “\r\n” at the end of our string.
A carriage return, sometimes known as a cartridge return and often shortened to CR, <CR> or return, is a control character or mechanism used to reset a device's position to the beginning of a line of text.
In VBA, vbCrLf is the line break constant (along with vbCr and vbLf).
In a string data column, it's Chr(13) + Chr(10) (which is what vbCrLf is defined as).
64
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
