Check for numbers in a combo box

slenish · #1 03-16-2010, 01:43 PM

Hello,

Ok I have a combo box that I set up so that you can only enter in letters in to it. At the moment it works great! If you enter numbers in you get an error message but I just did another test where if I enter a combination of numbers and letters it will save. How do i get the box to check for if numbers are mixed in with letters to error out?

Here is the code I have so far,

Code:

If IsNumeric(Me![Combo57].Text) Then
  MsgBox "You must enter letters in this field", vbYes, "Invalid Entry"
   Response = acDataErrContinue
    Me![Combo57].Undo
     Exit Sub
End If

Not sure If I can add to this one, or do i need to make another if statement.

Apperciate the help

Stressed · #2 03-17-2010, 04:14 AM

Quote:

Originally Posted by slenish

Hello,

Ok I have a combo box that I set up so that you can only enter in letters in to it. At the moment it works great! If you enter numbers in you get an error message but I just did another test where if I enter a combination of numbers and letters it will save. How do i get the box to check for if numbers are mixed in with letters to error out?

Here is the code I have so far,

Code:

If IsNumeric(Me![Combo57].Text) Then
  MsgBox "You must enter letters in this field", vbYes, "Invalid Entry"
   Response = acDataErrContinue
    Me![Combo57].Undo
     Exit Sub
End If

Not sure If I can add to this one, or do i need to make another if statement.

Apperciate the help

I posted some code that will prevent numbers from being entered. No need for IsNumeric...

http://www.accessforums.net/database-design/setting-field-only-accept-text-characters-not-numbers-4763.html#post16706

c_smithwick · #3 03-17-2010, 05:03 PM

set your combo box input mask property to "???????????" (number of question marks equal to the maximum length of your possible entries. This will restrict entry to letters only, with each position optional so you can enter from 0 to the maximum number of letters permitted.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
check box criteria?	kzoll@mindspring.com	Queries	3	11-24-2009 06:43 AM
Check Box Value	mulefeathers	Programming	4	10-09-2009 06:31 PM
Limit combo box 2 values based off of combo box 1 selection	jmartin	Forms	1	08-26-2009 08:45 AM
Filtering subform combo from main form combo	MUKUDU99	Forms	0	08-17-2008 10:19 AM
check boxes	chiefmsb	Forms	1	11-14-2006 11:22 AM