Results 1 to 11 of 11

Thread: msgbox

  1. #1
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224

    Unanswered: msgbox

    in the msgbox("TEXT")
    how do i make the text bold and increase the font size

  2. #2
    Join Date
    Apr 2003
    Location
    Alabama, USA
    Posts
    154
    I don't think that it is possible to bold or even format text in a msgbox within VBA. The only thing I know of is that you can insert line breaks, e.g. "Text1" & vbNewLine & "Text2"


    If you do require bolding and colors in a msgbox, I suggest the use of a form with labels for your text in place of a VBA msgbox. You have control over the formating of a label in a form than a VBA msgbox.
    http://AccessDB.Info

    You live and learn. At any rate, you live. - Douglas Adams

  3. #3
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224
    how wud i do it using a form
    I guess I know how to make the form to resemble the msgbox but
    I need to make a form that takes in diffrent display text

    how do i do that

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    One way would be to create a custom sub that would accept the text, open the form, and set your label to the text you'd like.

    Something like:
    Code:
    Public Sub CustomMsgBox (msg As String)
    Dim frm As Form
    
    Set frm = frmCustomMsgBox
    DoCmd.OpenForm frm.name, acNormal
    
    frm.lblMessage.Caption = msg
    
    End Sub
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Jan 2004
    Location
    Sunnyvale, CA
    Posts
    14

    Smile These are Windows settings

    Text attributes of a message box are controlled by Windows. If you go to Control Panel, then Display, then Appearance, you should be able to set text attributes for all your message boxes.

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Quote Originally Posted by DeeperLook
    Text attributes of a message box are controlled by Windows. If you go to Control Panel, then Display, then Appearance, you should be able to set text attributes for all your message boxes.
    That wouldn't affect the appearance on his clients machines unless he changed the default setting on every single machine that this app will be installed on.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  7. #7
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224
    m not sure that i understand teddys method

  8. #8
    Join Date
    Apr 2003
    Location
    Alabama, USA
    Posts
    154
    Here is a sample (Access 2000).

    You will notice that I have created a module (basFrmMsgBox) to open the form. The form that acts as a message box must also have it Modal property set to YES (or TRUE).

    Hope this helps!
    Attached Files Attached Files
    http://AccessDB.Info

    You live and learn. At any rate, you live. - Douglas Adams

  9. #9
    Join Date
    Jan 2004
    Location
    Sunnyvale, CA
    Posts
    14

    Smile Windows settings

    Quote Originally Posted by Teddy
    That wouldn't affect the appearance on his clients machines unless he changed the default setting on every single machine that this app will be installed on.
    But he could let the users know that they can set it in Windows to their own tastes. Every Windows user should know how to do this.

  10. #10
    Join Date
    Nov 2003
    Posts
    1,487
    Here's a concept for ya.....use the office animator. Sheesh...you can do whatever you like then and it adds a little flare to your app. *if you like that sort of thing.



  11. #11
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Quote Originally Posted by DeeperLook
    Every Windows user should know how to do this.
    lol

    Hi, welcome to the land of IT professionals, and consequently end users.

    I hope you enjoy your stay.

    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •