[AccessD] Checking input datatype

Thanks, David

Both for your prompt reply and your answer, it works perfectly

David

At 07:09 AM 9/04/2005, you wrote:
>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
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com