Microsoft KB Archive/90810

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

Article ID: 90810

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q90810



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



SUMMARY
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 where 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!

and, you wanted the message to be displayed as

  Notice: This is an Important Message!

you would enter the message as a string expression with the following syntax in either a macro or in code:

In a Macro

--

Action

--

MsgBox

Message: =&quot;Notice:&quot; & Chr(13) & Chr(10) & &quot;This is an Important Message!&quot;

NOTE: You must use the equal sign (=) with the MsgBox action to tell the action that you are using a string expression as the message argument.

In Code

---

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

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 &quot;Notice:&quot; & vbCrLf & &quot;This is an Important Message!&quot;

Additional query words: multiline

Keywords: kbhowto kbusage KB90810

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.