Select vs IsDate()

[JethroUK©]

I'm trying to detect whether a date has been typed into a box (cboFILTERS):

Select Case cboFILTERS
Case "NEED A LETTER"
blah
Case "NEW STARTS"
blah
Case "ACTIVE CLIENTS", "ENROLLED NOT SUBMITTED"
blah
Case IsDate(cboFILTERS) '<<<<<<<<<<< it doesn't seem to like this at
all
blah
Case Else
blah
End Select


any clues?

 

[Dirk Goldgar]

I'm trying to detect whether a date has been typed into a box
(cboFILTERS):

Select Case cboFILTERS
Case "NEED A LETTER"
blah
Case "NEW STARTS"
blah
Case "ACTIVE CLIENTS", "ENROLLED NOT SUBMITTED"
blah
Case IsDate(cboFILTERS) '<<<<<<<<<<< it doesn't seem to like
this at all
blah
Case Else
blah
End Select


any clues?

Select Case cboFILTERS
Case "NEED A LETTER"
blah
Case "NEW STARTS"
blah
Case "ACTIVE CLIENTS", "ENROLLED NOT SUBMITTED"
blah
Case Else
If IsDate(cboFILTERS) Then
blah for date
Else
blah for non-date
End If
End Select

 

[JethroUK©]

thankyou

Select Case cboFILTERS
Case "NEED A LETTER"
blah
Case "NEW STARTS"
blah
Case "ACTIVE CLIENTS", "ENROLLED NOT SUBMITTED"
blah
Case Else
If IsDate(cboFILTERS) Then
blah for date
Else
blah for non-date
End If
End Select


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)