Actually, a field value 7/7/05 and how do I change it to 07072005 as a
string? Thanks.


"Marshall Barton" wrote in message
...
00Eric Clapton wrote:

What is the function which can convert date field to string in a specific
format?


The function you're looking for is Format()

Check Help for the function and the Format Property for
details.

--
Marsh
MVP [MS Access]