Message box strings in XP

[PaulSpell]

I've just converted a number of databases to XP. No real problems except that annoyingly where I have used '@' to bold the first line of message box strings in A97, this does not appear to be supported in XP. Is this correct (i.e. it is not supported)?

If so, does anyone know of an XP alternative to bold the first line?

 

[SforSoftware]

Paul,

This functionality is not supported in VBA onder Acc 2000 and XP, but there's an alternative

You can use the Eval()-function, which does the same as a macro. For example:

Eval("MsgBox(""Here your message@, between two double quotes@"", 4, ""Title"")")

4 is the sum of the options u want to use, see VBA-Help on Msgbox to get the values of the options.

Succes,
Bert

 

[PaulSpell]

So all I have to do is encase each msgbox with eval() and it will work?

 

[SforSoftware]

Yes,

Because with Eval() you call the expression, and that's the same like giving the command in eg a macro, where the bold line still is supported.

But be alert with including variables, because the whole MsgBox is included in a string within Eval()

Good luck,
Bert

 

[PaulSpell]

Thanks a lot.