<div>
For general error handling you would do something like the below<br />
<br />
Sub FormSave<br />
<br />
On Error GoTo errHandler<br />
<br />
...<br />
<br />
&nbsp; Exit Sub<br />
errHandler:<br />
&nbsp; MsgBox &quot;Error &quot;&nbsp;&amp; Err.Number &amp;&nbsp;&quot;: &quot;&nbsp;&amp; Err.Description &amp;&nbsp;&quot; in &quot;&nbsp;&amp; _<br />
&nbsp; &nbsp;VBE.ActiveCodePane.CodeMod<wbr />ule, vbOKOnly, &quot;Error&quot;<br />
End Sub<br />
<br />
<br />
For validating input on a form and giving a very customized message you may have to write some customized code behind a save button that validates user imput
</div>


For general error handling you would do something like the below

Sub FormSave

On Error GoTo errHandler

...

  Exit Sub
errHandler:
  MsgBox "Error " & Err.Number & ": " & Err.Description & " in " & _
   VBE.ActiveCodePane.CodeModule, vbOKOnly, "Error"
End Sub


For validating input on a form and giving a very customized message you may have to write some customized code behind a save button that validates user imput

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I'm having difficulty finding a resource for error handling that I actually understand. &nbsp;If I wanted to modify the message 'You must enter a value in the 'XXX' field, how would I go about it?<br />
<br />
I would just like to change the text message that displays and have an OK button while eliminating the &nbsp;'Help' button that shows.<br />
<br />
Thanks!
</div>
</div>


Hi Experts,

I'm having difficulty finding a resource for error handling that I actually understand.  If I wanted to modify the message 'You must enter a value in the 'XXX' field, how would I go about it?

I would just like to change the text message that displays and have an OK button while eliminating the  'Help' button that shows.

Thanks!

Modify 'You must enter a value in the 'XXX' field (Access 2010)

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.