P
Paolo
Hi
Anybody knows how I can make a word in bold in a message box?
Thank you
Paolo
Anybody knows how I can make a word in bold in a message box?
Thank you
Paolo
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Brendan Reynolds
There is a way to bold the first line in a MsgBox. I don't know of a way to
bold a word within a line, or a line other than the first one. If the first
line will do, check out Michael Kaplan's article 'The formatted MsgBox in
Access 2000' at ...
http://www.trigeminal.com/usenet/usenet015.asp?1033
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
bold a word within a line, or a line other than the first one. If the first
line will do, check out Michael Kaplan's article 'The formatted MsgBox in
Access 2000' at ...
http://www.trigeminal.com/usenet/usenet015.asp?1033
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
P
Paolo
Nope the @ sign is obsolete...
Brendan Reynolds said:There is a way to bold the first line in a MsgBox. I don't know of a way
to bold a word within a line, or a line other than the first one. If the
first line will do, check out Michael Kaplan's article 'The formatted
MsgBox in Access 2000' at ...
http://www.trigeminal.com/usenet/usenet015.asp?1033
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
B
Brendan Reynolds
I'm not sure what your point is. The article at the URL I posted
demonstrates how to make the '@' work in Access 2000 and later. But if that
doesn't meet your needs, then as far as I know the only alternative is to
use a custom form instead of the built-in MsgBox.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
demonstrates how to make the '@' work in Access 2000 and later. But if that
doesn't meet your needs, then as far as I know the only alternative is to
use a custom form instead of the built-in MsgBox.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
A
Arvin Meyer
And a custom "msgbox" form is available that does just that at:
http://www.datastrat.com/Download/MsgBox2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.datastrat.com/Download/MsgBox2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
P
Paolo
Hey I tried to use the function that Brendan sent me, I copied it and
created a new module. I am sorry I am just starting now to use VBA in Access
and still struggling with fully understanding how it works. In my message
box I already have written a vbNewLine... could that affect the use of th @,
as despite the creation of the module containing Brendan's function the @
symbol still prints on the message box...
Am I making any sense???
created a new module. I am sorry I am just starting now to use VBA in Access
and still struggling with fully understanding how it works. In my message
box I already have written a vbNewLine... could that affect the use of th @,
as despite the creation of the module containing Brendan's function the @
symbol still prints on the message box...
Am I making any sense???
A
Arvin Meyer
I can only tell you that I developed my custom message box form before the
other code was written, and have tested it in all versions of Access since
version 7.0.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
other code was written, and have tested it in all versions of Access since
version 7.0.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
Í
íÉÎÉÎ ðÁ×ÅÌ
Arvin Meyer said:I can only tell you that I developed my custom message box form before the
other code was written, and have tested it in all versions of Access since
version 7.0.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
th is with
B
Brendan Reynolds
It's not my function, it's Michael Kaplan's, but I just tested it, and it
works without or without a vbNewLine in the prompt ...
Function FormattedMsgBox( _
Prompt As String, _
Optional Buttons As VbMsgBoxStyle = vbOKOnly, _
Optional Title As String = vbNullString, _
Optional HelpFile As Variant, _
Optional Context As Variant) _
As VbMsgBoxResult
If IsMissing(HelpFile) Or IsMissing(Context) Then
FormattedMsgBox = Eval("MsgBox(""" & Prompt & _
""", " & Buttons & ", """ & Title & """)")
Else
FormattedMsgBox = Eval("MsgBox(""" & Prompt & _
""", " & Buttons & ", """ & Title & """, """ & _
HelpFile & """, " & Context & ")")
End If
End Function
Public Sub TestFormattedMsgBox()
Dim strPrompt As String
strPrompt = "Wrong button!@This button doesn't work.@Try another."
FormattedMsgBox strPrompt
strPrompt = "Wrong " & vbNewLine & "button!@This button doesn't work@Try
another."
FormattedMsgBox strPrompt
End Sub
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
works without or without a vbNewLine in the prompt ...
Function FormattedMsgBox( _
Prompt As String, _
Optional Buttons As VbMsgBoxStyle = vbOKOnly, _
Optional Title As String = vbNullString, _
Optional HelpFile As Variant, _
Optional Context As Variant) _
As VbMsgBoxResult
If IsMissing(HelpFile) Or IsMissing(Context) Then
FormattedMsgBox = Eval("MsgBox(""" & Prompt & _
""", " & Buttons & ", """ & Title & """)")
Else
FormattedMsgBox = Eval("MsgBox(""" & Prompt & _
""", " & Buttons & ", """ & Title & """, """ & _
HelpFile & """, " & Context & ")")
End If
End Function
Public Sub TestFormattedMsgBox()
Dim strPrompt As String
strPrompt = "Wrong button!@This button doesn't work.@Try another."
FormattedMsgBox strPrompt
strPrompt = "Wrong " & vbNewLine & "button!@This button doesn't work@Try
another."
FormattedMsgBox strPrompt
End Sub
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.