Select vs IsDate()

  • Thread starter Thread starter JethroUK©
  • Start date Start date
J

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?
 
JethroUK© said:
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?
Click to expand...

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
 
thankyou

Dirk Goldgar said:
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)
Click to expand...
 
Back
Top