Line Feed in VBA Line Feed in VBA PL01 (TechnicalUser) (OP) 21 Feb 12 20:28 What is the command to have VBA break up a block of text? i.e.Var = "This Block of text is " & [new line here] & "too long for a single line".What VBA code will break the text up into two lines when it comes up on the form or in a report? RE: Line Feed in VBA jges (TechnicalUser) 21 Feb 12 20:53 vbcrlfWhich is a VB constant for Carriage Return and Line Feed. It is shorthand named constant for the combination of Chr(13) & Chr(10). RE: Line Feed in VBA georgesOne (TechnicalUser) 22 Feb 12 01:10 My recommendation: define constants in a general module like Public Const NL As String = vbNewLine 'New line Public Const DL As String = NL & NL 'New line after space Public Const DQ As String = """" 'Double quotes Public Const S12 As String = " " '12 Spacesand then use your own short-cut constantslikeMsgbox "This Works." & NL & "Good!"Best, georgesOne RE: Line Feed in VBA PL01 (TechnicalUser) (OP) 22 Feb 12 13:41 thanks. I had tried Chr10 and Chr13 but not together. RE: Line Feed in VBA TheAceMan1 (Programmer) 22 Feb 12 20:40 How are ya PL01 . . .You can also use the constant vbNewLine. I always have the following two constants in the declaration header of a module for global access:CODEPublic Const NL As String = vbNewline 'new linePublic Const DL As String = NL & NL 'skip a lineAs an example I'll breakup the following "Now is the time For all good men To come to The aid of their countrymen"CODE Dim str As String str = "Now is the time" & NL & _ "For all good men" & NL & _ "To come to" & NL & _ "The aid of their countrymen" Debug.Print strYour Thoughts? . . . See Ya! . . . . . .Be sure to see FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions? Worthy Reading! Also FAQ181-2886: How can I maximize my chances of getting an answer? Worthy Reading! RE: Line Feed in VBA SkipVought (Programmer) 23 Feb 12 08:44 OLD definitions in the mechanical typewriter/printer days:Carriage Return: The command used to either return the carriage or printhead, to the beginning-of-line position, as in an old typewriter. Used alone, the previously typed characters in the line, could be overtyped.Line Feed: The command used to turn the platen forward one position. Used alone, produces a result like... Line Feed here--+ | VNow is the time for all good men to come to the aid of their country. Skip,Just traded in my old subtlety...for a NUANCE! RE: Line Feed in VBA hermanlaksko (Programmer) 24 Feb 12 06:41 One can use one of the followingvbCrLf - Carriage Return and Line FeedvbCrvbLfvbNewLine - Carriage Return and Line Feed HermanSay no to macros RE: Line Feed in VBA PL01 (TechnicalUser) (OP) 24 Feb 12 10:35 ...thank you very much for the information. But where are all the VBA commands conveniently indexed? I searched high and low for them in Access help. Is there a definitive text? I use the two Access for Idoits books which are very good to learn from - but the indexing is completely deficient. It's difficult to finds things in the thousand pages. RE: Line Feed in VBA PHV (MIS) 24 Feb 12 10:44 When in the VBE the F2 and F1 keys are your friends. Hope This Helps, PH.FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?FAQ181-2886: How can I maximize my chances of getting an answer?