check text box for letter or number

M

mike

Hi all,

How do i check to see if the user enter alphabets or
numbers in a text box?

Thanks for the help.

mike
 
C

Cheryl Fischer

To check the entirety of the entry in the text box, insert the following
code in the After Update event of the text box:

If IsNumeric(Me!MyTextBox) then
' do something
else
' do something else
End If

If you need to evaluate on a character-by-character basis, review the
KeyPress Event in VBA Help.
 
M

mike

cool, thanks
-----Original Message-----
To check the entirety of the entry in the text box, insert the following
code in the After Update event of the text box:

If IsNumeric(Me!MyTextBox) then
' do something
else
' do something else
End If

If you need to evaluate on a character-by-character basis, review the
KeyPress Event in VBA Help.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX




.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
List Box Selection 7
Check box to control editablility of text box and return all recor 1
Typing in a field to find records that match 10
change in text box applies filter to combo box to show only those 3
duplicate check before report runs 5
list box to verify data entry-can't stop auto trailing entry inclu 1
Use record number of subform to assign letters 4

Top