[Previous] [TOC] [Next]

Formatting

Follow these rules when formatting your code:

• Punctuate your code with blank lines.
• Keep your procedures to a manageable size-preferably not much more than a single screen.
• Keep indentation under control. If you're having difficulty remaining within the right margin, you're probably nesting too deeply.
• Use parentheses to enhance the readability of your code. No one reading your code should have to wonder what you meant when you wrote it.
• Preserve screen real estate wherever possible. For example, when creating a long string, it might be better to build up the string with multiple assignments:

    Dim sMsg As String
  
    sMsg = "This is a paragraph that is to appear "
    sMsg = sMsg & "in a message box. The text is "
    sMsg = sMsg & "broken into several lines of code "
    sMsg = sMsg & "in the source code, making it easier "
    sMsg = sMsg & "for the programmer to read and debug. "
  
    MsgBox sMsg, vbOkOnly, "Text"
  
    Dim sQRY As String
  
    sQRY = "SELECT Customer.CustomerName, Orders.OrderValue "
    sQRY = sQRY & "FROM Customer, Orders "
    sQRY = sQRY & "WHERE Customer.CustomerId = Orders.CustomerId"
  
    ReportQry1.SQL = sQRY
  
  

[Previous] [TOC] [Next]