the at symbol (@) in a messagebox

[BillNielsen]

Hi All

I have a form where an user can eliminate Email addresses from a list box. Once the user has selected the number of Email addresses, I'm trying to to alert the user of the addresses that are about to be eliminated in a messagebox. The problem is the at symbol (@) in the email address is also a formatting deliminator and causes the messagebox display the text incorrectly.

To illustrate my problem try this code: MsgBox "someone@hotmail.com" & Chr(13) & "someone@yahoo.com"

Can someone explain how to display the message with text as it should read? Or even some more information on how the at symbol,@, works inside a message box.

Thanks,
Bill N

 

[Cagliostro]

"someone" + chr(64) + "yahoo.com" John Fill

ivfmd@mail.md

 

[JoeMiller]

Bill,

In Access97 you can't use the "@" symbol by any method in a MsgBox because of the special formatting that it does, at least I couldn't find anything on it. I checked a bunch of places and noone had a workaround. Using Chr() doesn't work as John suggested. The only thing I can suggest is to make a form like a MsgBox and open it up to display your data to the user. Then you'll be able to use @ all you want. Sorry I don't have a better answer..
Joe Miller
joe.miller@flotech.net