<div>
Hello eyes59,<br />
<br />
MsgBox *always* requires the user to clear it by clicking something. &nbsp;If you want to show a message to the<br />
user without waiting for the user to do something, then you will need to create your own form, which you<br />
can make modeless if you want.<br />
<br />
Regards,<br />
<br />
Patrick
</div>


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.

Regards,

Patrick

untitled.JPG

<div>
<div class="content wysiwyg-content">
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. &nbsp; &nbsp;Which vb* can I use to have the messge appear BUT not require a response?<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />

<pre><code id="code-258471">If cmbxErrSource.Value = &quot;3&quot; Then
             MsgBox &quot;If the Source of Issue is HOME OFFICE this field is REQUIRED&quot;, vbOKOnly + vbInformation, &quot;Required Field&quot;
             Me.cmbxIssueDes.SetFocus
             Me.cmbxIssueDes.Dropdown
             Me!cmbxIssueDes.BorderColor = lngRed
             Me!cmbxIssueDes.ForeColor = lngRed
             Me!cmbxIssueDes.BackColor = lngWhite
</code></pre>
</div>
</div>


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?









No response for MsgBox

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.