date formats

[TimTDP]

In VBA with Access 2000 I have string called dteNew. The value displayed for dteNew is 03/11/2009
However when I write it to a field it is displayed in the table as 30/12/1899.
If I hover the mouse over the field in the table, the 30/12/1899 changes to 12:00:12am!

how do I write the value 03/11/2009 to the table? I have tried Format(dteNew , "dd/mm/yyyy") but this does not work

thanks in advance

[vb5prgrmr]

try surrounding the date with either single ticks " ' " or the pound symbol #



Good Luck