Set the Format Propertie of the TextBox to YL. Then this TextBox will display the Long Date Format. How it will display dependent depends of system seting in Regional Options of the OS.
>Dear Experts
>
>There are two textboxes on form1.
>Data type of Text1 is date with british date type.
>
>The date in text1 is 22-11-2004
>
>I want to get this date, in text2, in following format
>
>November 22, 2004
>
>Please help
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.