MsgBox Help

  • Thread starter Thread starter Douglas J. Steele
  • Start date Start date
D

Douglas J. Steele

If MsgBox("This is the first line" & vbCrLf & "This is the second line"",
vbYesNo) = vbYes

To add the icons, you add values to the vbYesNo flag. Use vbQuestion for the
question mark icon, vbCritical for the error icon, and vbInformation for the
exclamation mark icon:

If MsgBox("This is the first line" & vbCrLf & "This is the second line"",
vbYesNo + vbQuestion) = vbYes

If you're using Access 2000 or newer, check
http://www.trigeminal.com/usenet/usenet015.asp at Michka's site for how to
get bold lines in the message box. If you're using Access 97, check "@
(message box section separator)" in the Help file. I'm not sure whether it
was available in previous versions to 97.
 
This is my code:

If MsgBox("Would you like a catagory for this record?",
vbYesNo) = vbYes

How do I display the output in more than one line, like 2
or 3 lines so I can output more info?

Thanks Allen.
 
This is my code:

If MsgBox("Would you like a catagory for this record?",
vbYesNo) = vbYes

How do I display the output in more than one line, like 2
or 3 lines so I can output more info?

Thanks Allen.
Click to expand...

Dim strMsg As String
strMsg = "Would you like a category" & vbCrLf & "for this record?"
If MsgBox(strMsg, vbYesNo) = vbYes Then
...
 
Thanks, Paul. It's been so long since I used Access 2.0 (and I never really
did use Access 95)
 
Back
Top