MsgBox

[Paul]

I'm using Acess 2000. There use to be a way to put a title, icon,
sound and put texts in separate lines using the MsgBox in earlier
versions of Access. Can this still be done in Access 2000 without
actually creating a pop-up modal form? Thanks in advance.

[fredg]

Re: MsgBox

On 30 Sep 2004 21:09:47 -0700, Paul wrote:
[color=blue]
> I'm using Acess 2000. There use to be a way to put a title, icon,
> sound and put texts in separate lines using the MsgBox in earlier
> versions of Access. Can this still be done in Access 2000 without
> actually creating a pop-up modal form? Thanks in advance.[/color]

Sure.
MsgBox "this is line 1." & vbNewLine & "This is line 2.",vbInformati on
+ vbYesNo,"this is the title."

As far as sound goes, you can set the sound when the message box opens
from the Windows control panel.
Start + Control Panel + Sounds and Audio devices + Sounds.
Set the default beep to whatever sound you fancy.
This will affect in ALL Office programs, not just Access.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[user_5701]

Re: MsgBox

That sound setting will of course only work on your own computer, not
any other user's computer. Fredg pretty much answered your question,
I just wanted to add that I've always used vbcrlf (which stands for vb
control return line feed) to go to the next line.

fredg <fgutkind@examp le.invalid> wrote in message news:<1j7zwob9e nwju$.7cm4pd04y xiq.dlg@40tude. net>...[color=blue]
> On 30 Sep 2004 21:09:47 -0700, Paul wrote:
>[color=green]
> > I'm using Acess 2000. There use to be a way to put a title, icon,
> > sound and put texts in separate lines using the MsgBox in earlier
> > versions of Access. Can this still be done in Access 2000 without
> > actually creating a pop-up modal form? Thanks in advance.[/color]
>
> Sure.
> MsgBox "this is line 1." & vbNewLine & "This is line 2.",vbInformati on
> + vbYesNo,"this is the title."
>
> As far as sound goes, you can set the sound when the message box opens
> from the Windows control panel.
> Start + Control Panel + Sounds and Audio devices + Sounds.
> Set the default beep to whatever sound you fancy.
> This will affect in ALL Office programs, not just Access.[/color]