Form field switching date and month field?

[paulmcdonnell]

Hi guys.

Have a strange one.

When I put a date in a form field (UK) like 10/03/2009 the form field immediately switches the date to be 03/10/2009.

No idea what's going on here.

All other software doesnt do this.

using Access 97 in this oldie.

Anyone have any ideas why this might be?

Thanks
Paul

 

[jsv2002]

Been a long time since I used Access 97 but the date format is usually picked up from your windows regional settings are you sure they are set to Uk and not US also check the date format in the table you have created.

Good luck John