Manufacturing Information Solutions

[BIGmiralli]

I want to bold a word in a message box, how can I do that?
________
EXTREME VAPORIZER

[dawn]

Developer's since Access 1.x have used the combination of Chr(10) & Chr(13) & Chr(10) to break message boxes into paragraphs. Since Access 95 you could use the intrinsic constants "vbCrlf" to do the same thing.
Both Access 95 and 97 allow you to not only break your message box into paragraphs, but also allow you to bold the first paragraph in the Message Box, just like Access itself does with standard messages. However, creating this functionality in Access 2000 this is a bit more limited and tricky as noted below.
The "@" symbol added to your message text will break the message into paragraphs, with text before the first @ shown in bold. You are limited to three paragraphs with the "@" symbol following each paragraph. If you only want to break for two paragraphs, you must use two @@ symbols at the end of the second paragraph.
The following code shows a formatted message box for Access 95-97:

[mistux]

Creating the FormattedMsgBox Function

The Eval function forces the Visual Basic for Applications expression service to evaluate the MsgBox function separately from Visual Basic Editor, and therefore it is possible to take advantage of at sign formatting. The following example uses a user-defined function named FormattedMsgBox instead of the MsgBox function.

To create the FormattedMsgBox function, follow these steps:

1. Start Microsoft Access.
2. Open the sample database Northwind.mdb.
3. Create a new module.
4. Add the following procedure to the module:

[mistux]

You could also just crate a small little pop-up form that is "model" that has the info you want on it with the buttons you want.