Date validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a textbox on a form used to capture the start date used as a
parameter for a query. I want to validate that the date is valid. For
example, Feb 29, 2005 is invalid, and currently it breaks the sql code. Is
there a way to check the date in the textbox before executing the query?
thanks in advance for any assistance.
 
Try this

On the before update event of the Text field write the code
=======================================
On error goto MySub_Error
Dim MyDate
' If the cvdate will get an error it will prompt the user with a message
MyDate = CvDate(Me.[TextFieldName])
Exit Sub

MySub_Error:
msgbox "Error in date"
cancel = True 'wont let the user exit the field
==================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation Text 1
Validation and Popup Calendar 5
Date as a value to a textbox as a result from another textbox 1
Multiple Validation Rules 1
Validation Rule in Table 2
need a textbox control Validation event ... 3
Date Validation Current Date / Past 45 Days / Null OK 2
Me.Undo and validation of fields 5

Back
Top