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