![]() ![]() Here’s one more example, used to output the content of a recordset so that each record is on a single line. While Debugging, this format is much easier to read and tweak. So the outputs 2 lines, one with just the Caption and a 2nd line with all the details for that entry. Rather than creating a really long variable, string, … you can simply Debug.Print each on their own line, but use the so they continue to print out on the same line in the VBA/VBE Immediate Window. This can be very helpful when building long output. So we can now split the Debug.Print into multiple lines while having the output remain on a single line. Now, the example above doesn’t do it justice, so let’s try another more concrete example a = "Some" Thus, it allows us to continue to output content on the same line as the previous output. The is a continuation operator telling the output to continue from the current position. Normally, when you perform a Print, it outputs the ‘value’ and then you start fresh on a new line. Use a semicolon ( ) to position the insertion point immediately following the last character displayed. ![]() If you look at the documentation for a moment, you will see they mention Spc(n), Tab(n) &, so what are these and how do they work. There are times that it is useful to insert separation lines, a blank line and this is very easy to do! Simply do either Debug.Print Which will the return (in the VBE Immediate Window) Some Value ![]() you can sprinkle it throughout procedure to see the evolution of variables, … in real-time. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |