Rather than using a macro, associate the vba to your On_Click event of
your button.
The format of the message box would be:
MsgBox "Please call Dawn for assistance at x411, or you can email her at
[EMAIL PROTECTED]" & _
vbCrLf & "You can also contact Steve through the same phone or email
him at [EMAIL PROTECTED]" & _
vbCrLf & "If your problem is an emergency please page us at
800-111-1111", , "Help Contacts"
The Message Box components are:
MsgBox Prompt[ , buttons] [ , Title] [ , HelpFile] [ , Context]
The vbCrLf commands are the new line entries inside the message box.
The & _ is the continuation command which is needed if you don't want
your code to be however many characters long across the page. They are
there for readability sake. Except that the & is also a concatenation
character. It is used to string the text together with the linefeed
commands.
Hope that helps.
Dawn Crosier
Application Specialist
Microsoft MVP
"Education Lasts a Lifetime"
This message was posted to a newsgroup. Please post replies and
questions to the group so that others can learn as well.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of rokkeee
Sent: Friday, January 20, 2006 2:03 PM
To: [email protected]
Subject: [ms_access] email contact info in msgbox
I want to enter several lines of text into an informational/msg box for
other users to contact if they need to call for help. There are three
names along with their phone numbers and email addresses. The email
address is a problem when using the @ symbol in the message line of the
macro. How can I manipulate the email address so it appears correctly?
Or what other way should I do this?
Thanks,
Doreen
Yahoo! Groups Links
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
