vbCrLf Constant?

[Dalain]

I have recently see some code that uses the Constant vbCrLf , but I have not been able to find the definition where to use it and what does it realy does.

Is this simply a new way to saying Chr(13) in a MsgBox?

Thanks in advance
Dalain

 

[THWatson]

Dalain
vbCrLf is the Visual Basic format for Carriage Return & Line Feed.

Instead of using Chr(13) & Ch(10) in the Message Box, you could use
MsgBox "Put this code " & vbCrLf & "into two lines"

The message box output would be
Put this code
into two lines

Tom

 

[Eupher]

Actually it's equivalent to a combination, or concatenation, of two characters: Chr(13) + Chr(10)

Check the VBA help for Constants->Miscellaneous Constants.

HTH...

Ken S.

 

[Dalain]

Thanks, this make alot more sense to me now.

I hate MS Access Help. I had already tried the Answer Wizard, but of course no resaults. It does not seem to search the Contents part of the Help File. But as Eupher mentioned it is in there. Is there an easier way to search the help file, because reading the entire Contents part just to find someting would take long.?

Dalain

 

[Eupher]

If it's a VBA question, I just open a code window and type my search term(s) into the Help window. But you're right, there doesn't seem to be any mechanism for searching all the associated help files. If you're in the main Access window, your search results will be entirely different from those you will get if you look for help while in the VBE, which will be different from the results you will get while in the VBA Object Browser. Not a very intuitive arrangement.

Ken S.

 

[CajunCenturion]

Another way to "find" what you're looking for in the help is to type the word directly in your code, place the cursor over that word, and press F1.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein