No response for MsgBox

Posted on 2009-02-23
Last Modified: 2013-11-28
I would like the MsgBox in a vba module to run but I don't want to require the user to click on Okay I wrote coding to return to the empty field and change the border to bold red.    Which vb* can I use to have the messge appear BUT not require a response?

If cmbxErrSource.Value = "3" Then

             MsgBox "If the Source of Issue is HOME OFFICE this field is REQUIRED", vbOKOnly + vbInformation, "Required Field"



             Me!cmbxIssueDes.BorderColor = lngRed

             Me!cmbxIssueDes.ForeColor = lngRed

             Me!cmbxIssueDes.BackColor = lngWhite

Open in new window

Question by:eyes59
    LVL 92

    Expert Comment

    by:Patrick Matthews
    Hello eyes59,

    MsgBox *always* requires the user to clear it by clicking something.  If you want to show a message to the
    user without waiting for the user to do something, then you will need to create your own form, which you
    can make modeless if you want.


    LVL 74

    Accepted Solution


    Another option would be to use the "Web Form" method, which most websites have adopted, because of the hatred of popups.

    Modify your existing code that pops up the message, to just turn on an "Empty Field Alert" Label.

    Screenshot attached.



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now