MsgBox Function In An Access 2000 Project

[Backer26]

In Access 97 I was able to format my message boxes using @ symbols.&nbsp;&nbsp;For example, if I used the string <br><br><FONT FACE=monospace>&quot;Header@Body1@Body2&quot;</font><br><br>as the message parameter the message box would appear something like this:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>Header</b><br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Body1<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Body2<br><br>I am using Windows 2000 with an Access 2000 Project (.adp file) now and it doesn't work.&nbsp;&nbsp;Has Microsoft decided to take this feature away? Does anyone know anything about this?

 

[THWatson]

Hi Backer26<br>Although I am not yet well versed in all the intracicies of Access 2000, I tried doing exactly what you said, making a MsgBox in a Macro. It worked just fine.<br>My manuals also say this is the right way to do it. You separate the 3 clauses you want to use by the @ symbol. The first phrase appears in bold, and the other two in normal text, just as you indicate above.<br><br>If, for some reason, this doesn't work. You can separate the 3 lines by pressing Control-Enter following each line.<br>Tom<br>

 

[rhicks]

I can't remember where I found this but:<br><br>In Access 97, it's possible to have formatted (bolded) messages in MsgBox function.&nbsp;&nbsp;For example, this line<br><br>Msgbox &quot;Bold Line@Plain Line@Another Plain Line&quot;, _<br>&nbsp;&nbsp;&nbsp;&nbsp;vbInformation+vbOKOnly, _<br>&nbsp;&nbsp;&nbsp;&nbsp;&quot;Formatting sample&quot;<br>produces the first line in bold.<br><br>Access 2000 no longer supports this custom format from code.&nbsp;&nbsp;Therefore, Access 97 databases converted to Access 2000 format will lose this feature.<br><br>The custom MsgBox formatting is still supported by the Msgbox action in a macro.&nbsp;&nbsp;To use the Macro, you'll need to type the formatted string as the message (for example, &quot;Bold@Plain@Plain&quot for the MsgBox action in a new macro.<br><br>Another option if your application relies heavily on this type of formatting, would be to use a form in place of the MsgBox dialog and roll your own replacement for the MsgBox function.<br><br>HTH<br>RDH <br> <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>