[AccessD] Checking input datatype

dmcafee at pacbell.net dmcafee at pacbell.net
Fri Apr 8 16:09:12 CDT 2005


in the combo box OnChange event:
If LEN(me.cboMyCombo) >1 THen
	If ISNUMERIC(LEFT(me.cboMyCombo,1)) = True Then
		me.cboMyCombo.Rowsource = "qryNumberUsed"
	Else
		me.cboMyCombo.Rowsource = "qryLetterUsed"
	End if
ENd if

HTH
David McAfee
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David & Joanne
Gould
Sent: Friday, April 08, 2005 1:54 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Checking input datatype


I am trying to check for the datatype of a user's keyboard entry. They are
typing into a combo box that should check the first keystroke to see if it
is a number or a letter. Once it has decided which it is it can then choose
which query to use for the combo box. Everything is fine except that I
can't work out how to check the datatype.

TIA

David Gould
DG Solutions


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list