>Dear Experts
>
>I have tree string as
>
>Str1="Jan"
>Str2="31"
>Str3="2005"
>
>These strings are taken from three combo boxes.
>
>How to convert the value, of above said combo boxes, into a date type text1 as
>
>31-01-2005
>
>On the Interactivechange of every combo box, the value of text1 must change.
>
>Please help
Add a Method in The form i.e. CovertToDate
Put in InteractiveChange Event in each Combo:
thisform.CovertToDate()
*** Method CovertToDate
thisform.text1.Value = DATE(thisform.ComboWithYears.Value, thisform.ComboWithMonths.ListIndex, thisform.ComboWithDays.Value)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.