>Hi Bernard,
>
>>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.
>
>Others gave you the specific functions for DATETIME. But there are two functions that can handle all sort of different types:
>
> ? PadR( DateTime(), 20 )
> ? Transform( DateTime(), "" )
>
>Christof
Christof
Would you believe that until a few days ago(2) I always used the STR() to convert a number to char before using RPAD(),LPAD().
I will check out TRANSFORM(). The Fn I was looking for was TTOC().
Thanks
Bernard