You could just format the date field value once you get it:

MyStr = Format(MyRS.Fields("Audit_Date").Value,"dd/mm/yyyy")