msgbox, message box text font size

[Lydia]

Hi,

How do I change the text font size displayed on a pop up message box. The
default font size is too small. thanks.

 

[fredg]

Hi,

How do I change the text font size displayed on a pop up message box. The
default font size is too small. thanks.

You can change the Font Size setting via the overall Windows settings.
This will change the setting for ALL Windows based programs, not just
Access.
Right-click on an empty portion of the desktop.
Select Properties.
Click on the Appearance tab.
Click on Advanced.
Select the Message Box in the Item drop-down.
Change the Font Size and save the settings.

A better solution which will not affect other programs is to simply
create your own form to display your message.
Open the form in dialog when you wish to display your message:
DoCmd.OpenForm "MessageFormName", , , , , acDialog

Access will display your message and wait until a command button on
the form is clicked before further processing is done.

If you need further help, search groups.google for "custom message
box" or post back here.

 

[Lydia]

Thanks.

It worked for me by changing the setting in Window's properties. However I
would need to change every end user's computer who will use the database for
them to be able to see the same effect that I have, right?

I thought of creating a form. However I want to keep it as my last resort.

I can add line return characters like vbCrlf to make a long message to
appear on two rows, I just can't help thinking that there must be some
function that I can add into the message body to make the font size change
too.

Thanks.