How to Covert Date field to string

[kassem]

Hi,



I have a field in a form called DateCreated and its a date and time field in the format mm/dd/yyyy

how can i turn this into a string using VBA?

Thanks

[rpeare]

cstr([datefield])

you can use the cstr function either in vba code or in queries/reports/forms

[pbaldy]

Not clear on what you're trying to accomplish, but the Format() function returns a string.