Dunno if: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q142009 http://support.microsoft.com/default.aspx?scid=kb;en-us;Q149095 http://support.microsoft.com/default.aspx?scid=kb;en-us;Q208596 might help? --------------------------- Mike Hardaker Founder & Publisher - AngloINFO http://www.angloinfo.com > My Pc format dates into US format and it doing my head in! > > Regional settings: Admin: UK, every user on the pc is UK. > I'm using Session.LCID = 2057 (Uk date format) > The query i'm running using Now() as the date even write the date in UK > format!!!!! But for some messed up reason as soon as Access gets its hands > on it - wam bam thank you mam - US date format!!!!! aahhhhhhhhh!!!!!!!!!! > > Is there something in Access that makes the date US format?