<div>
Actually I am using the code in the 'Before Update&quot; event. It works well. The hyphen part does not work...
</div>


Actually I am using the code in the 'Before Update" event. It works well. The hyphen part does not work...

<div>
<div class="content wysiwyg-content">
I have text boxes that restrict the characters that are entered. The code is below:<br />
<br />
If Me.TextBoxName.Value Like &quot;*[!A-Z]*&quot; Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; MsgBox <br />
&nbsp; &nbsp; &nbsp; &nbsp; Cancel = True<br />
End If<br />
<br />
I need it to allow hyphens also...<br />
<br />
-Sariff
</div>
</div>


I have text boxes that restrict the characters that are entered. The code is below:

If Me.TextBoxName.Value Like "*[!A-Z]*" Then
        MsgBox 
        Cancel = True
End If

I need it to allow hyphens also...

-Sariff

Restrict characters in Text Box

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.