ACC: How to Force a New Line in a MsgBox Message

• Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

If you want to force a new line in a message box, you can enter the message as a string formula and concatenate a carriage return/line feed, Chr$(13) + Chr$(10), in the message anywhere you want to start a new line.

You can also use this technique to provide multiple lines in a text box on a form.

MORE INFORMATION

For example, if you had the message

   Notice: This is an Important Message!

   Notice:
   This is an Important Message!

 In a Macro
 ----------

  Action
  ------
  MsgBox
  Message: ="Notice:" & Chr(13) & Chr(10) & "This is an Important
  Message!"

  NOTE: You must use the equal sign with the MsgBox action to tell the
  action you are using a String expression as the message argument.

 In Code
 -------

  MsgBox "Notice:" & Chr(13) &Chr(10) & "This is an Important Message!"

  NOTE: When using the MsgBox statement or MsgBox() function in code,
  you do not need the equal sign before the message because this
  statement/function expects a string expression as the message argument.

  NOTE: While this code sample works fine in Microsoft Access 7.0 and 97,
  you can also use the Visual Basic constant vbCrLf in place of Chr(13)
  & Chr(10) in this code sample. The line of code would then read as
  follows:

     MsgBox "Notice:" & vbCrLf & "This is an Important Message!"