The other responses gave sometimes complicated ways of doing it. I'm not sure why. All you you have to do is TTOC(Dtime1).

-Michelle


>Help!
>
>I need to be able to display data from a DATETIME field as well as a CURRENCY field in a messagebox/ wait window and need to convert the data to a string.
>
>Is there any function to get the date and time as a string??
>
>eg the DATETIME field called Dtime1 has data 12/07/1999 14:23:44
>
>I need to display this the same way and need as a result a string as above "12/07/1999 14:23:44"
>
>How do I do this without extensive manipulation of hours(), minutes() etc??
>
>
>Bernard