Function to validate time

[anuragshrivastava64]

Can i get a function to validate time eneterd in a text box

[hariharanmca]

Can i get a function to validate time eneterd in a text box

Method:
Format(TimeValue,<Time Format>)
 
Example :
Format(txtTextBoxName.Text,"hh:mm:ss AM/PM")

this will help you

[hariharanmca]

Can i get a function to validate time eneterd in a text box

using text box for reciving Time from User is not good practice

Suggest you to use DTPicker.

[anuragshrivastava64]

Thnx
The format string string helped.
though i am not using DTPicker as it it is not user friendly

[hariharanmca]

Thnx
The format string string helped.
though i am not using DTPicker as it it is not user friendly

(I never thought) No Problem, Better validate tour text box.

[Killer42]

Can i get a function to validate time eneterd in a text box

Yes, the datetimepicker control has both good and bad points. It's not always appropriate.

One thing you might try, (not sure whether it's available in all versions) is the "Microsoft Masked Edit Control" (add in under Project | Components). This allows you much more control over the input than a standard textbox. Of course, you may still need to validate afterward, but at least you can enforce the general format of the input.

As for validating, perhaps the simplest way is to turn on error handling and try to convert the value to a time. For example (VB6)...

Dim T As Date
Dim S As String
' Assuming your value is in S...
On Error Resume Next
T = TimeValue(s)
If Err.Number Then
  Err.Clear
  ' Not a valid time.
End If
On Error GoTo 0