Is there a way to format variables when they are referenced in the msgbox function. It is hard to distinguish the value of the variable from the other words. I would like to format them in italics or make them bold or even a different color.

As an example the returned value of the variable is "BE Cap Retro Adjust Limit." I would like the message to look something like this.

You have selected BE Cap Retro Adjust Limit twice

Thanks,
Scott

__________________
ScottP

Hi,

   There really is no good way to do this using VBA since it uses a default system font. You could change that, but all your messages would be italicized.

   The best way to do this is to create a form that you use for messages with a text box and the buttons you want, like OK. Then format the font in the text box(es) on the fly, or make them all italicized. You will need to do this at runtime or the On Current event of the form.

HTH


mmcdonal

Thanks for the quick reply. I think using a form will work just fine. Thanks for your help.

Scott

Try one of these two approaches:

1) Emphasis with upper case

MsgBox "You have selected " & UCase(Me.txtVariable) & " twice.", vbExclamation, "Duplicate!"

or

2) Bold the first line of your message box only.

Eval ("MsgBox ('" & Me.txtVariable & "@@has been selected twice.'," & vbExclamation & ",'Duplicate!')")

Take special note of where the single and double quotes are. The @ signs will not show in the message box. Everything after them will be normal and on a new line. Everything before them will be bold and on the first line.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Oh, I'm using Access XP (2002) on Windows 2000 NT. I have no idea if option 2 will work with other Access/Windows combinations!

Thanks Greg, I used the second option and it works, although I am using Access XP also.

Thanks again for your help.

Scott