Text box (Unbound) to Date Type

[shimul]

Hi all,

I have a text box in form and it contains date (get value from combo box). Now I want to convert/change this text box to date type.

Is the anyway I can do it?

Thank you so much.
Shimul

[Stewart Ross]

Hi Shimul. To convert the text-based date in your textbox to a date type use the CDate function. Example in VBA:

Dim SomeDate as Date
SomeDate = CDate(Forms![name of your form]![name of the textbox])

Date/Time values are stored internally as decimal values, with the whole number part the number of days from 1 Jan 1900, and the decimal part the time. CDate converts the text date to its equivalent date type (an elapsed days value essentially), applying the current regional settings for interpretation of the month and day parts.

-Stewart

[NeoPa]

As Stewart says, there's not a way to make the TextBox control work as a Date control, but if you cast it on use (CDate()) then it should work for you reliably.