Change Font Characteristics in MsgBox

[RexesOperator]

Is it possible to change the font characteristics (bold, underline etc) or even the colour from one character to the next in a MsgBox? Or is this all predefined from the Windows properties?

 

[RexesOperator]

After some more searching the short answer is no. One solution is to use a form, but what I have will do.

 

[Uncle Gizmo]

I understand you can do quite snazzy things with MS Access 2007 in Vista, earlier versions arn't very helpful, I think you can use things like vbCtlf I'm pretty sure you can't use colors or bold, although I'm not absolutely sure, There may well be a work around I'm unaware of.

 

[Mike375]

Just a make a form that is set for PopUp and Modal. Have no borders on the form. Modal is what stops someone from clicing anywhere else on the screen.

On the form have a couple of buttons as required and they would each run another block of code or a macro and also close the modal form. Your code or macro would open the modal form based on conditions

If you think about the reasons you would use such a thing then it becomes easy to work out what you need to make. A couple of examples might be:

You want the form to open because someone has not entered date of birth or whatever. In that case no date of birth might be used to stop the code or macro from doing its thing. plus open the modal form. So your message is "Please Enter Date of Birth" and all the button on the modal form does is to close it.

Another situation could be where Access can't be used to make a decision and the modal form opens and it has a couple of buttons and each button runs a a different block of code or macro and closes the modal form.

 

[RexesOperator]

Thanks Mike. I have used similar techniques in other places in the program.

This MsgBox is used to remind users to keep a copy of a specific Excel spreadsheet in a specific place (the program uses the path to load data into the spreadsheet) AND to load the Excel Reference Library.

I was going to use Italics for a third message, but I simply open a second MsgBox instead.