Results 1 to 5 of 5
  1. #1
    Jerry Call is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    May 2020
    Champaign, Illinois

    Angry Changing font size in message boxes

    I know how to set font sizes for form objects in Access. But it seems that Microsoft
    engineeers left message boxes out of the picture. Browsing the web I found a few
    suggested vba solutions, but they seem quite intimidating to a novice like myself.
    If extremely long and complex vba code is required I'll just forget the idea and stick
    with the default 9 pt. until Microsoft condescends to redesign Access to
    accommodate message boxes fonts.

    But just in case somebody has thought of a reasonably simple way to bring up the
    size to, say, 12 pt, I thought I'd check in with the experts. I've already learned
    so much from you!

  2. #2
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    message boxes are a MS creation - a windows system object, nothing to do with access or vba. It may be complex vba can change the attributes (I'm not aware of anything) or it might be somewhere in windows settings - but if it is you would need to change it for each machine.

    Usual recommendation is to 'roll your own' - create a form to display the message.

    Alternatively, users can change their windows scaling - click on the windows icon in the task bar and type 'windows scaling'. But you might then need to adjust your application to suit.

  3. #3
    Jerry Call is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    May 2020
    Champaign, Illinois
    What an intriguing idea! Just create a small Access form which could come and go. I'll try it out, but if it's
    too much hassle I'll just stick with the small type. I don't have all that many message boxes, and the
    ones I have are usually quite short.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Ontario, Canada
    Maybe make it a function in a public module that opens your single purpose form that has several buttons on it, and show/hide the buttons as necessary - OK, Cancel, Yes, No.
    Pass the message string and values like True, False, False, False (for OK only) and show only 'True' buttons. That way, if it's a function you can also return the button click value to the calling code.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  5. #5
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Kelowna, BC, Canada
    I have been using for years the attached custom "message box" form by Dimitri Furman, I updated the declarations a while ago to make it compatible with both 32 and 64 bit versions.

    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 12
    Last Post: 01-12-2019, 06:02 PM
  2. Replies: 0
    Last Post: 07-27-2018, 02:17 PM
  3. Replies: 2
    Last Post: 02-03-2016, 09:54 AM
  4. Replies: 3
    Last Post: 07-28-2014, 03:02 PM
  5. Changing Font Color and Size in table
    By FormerJarHead in forum Access
    Replies: 2
    Last Post: 01-09-2013, 01:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums