UK/US Access Date headache

Im afraid its good old Date format and Access again folks (sorry)

Im making a list of league fixtures and coming across problems when updating individual fixtures because of the way that the form textfield reads in and updates the date.

When im entering a fixture from scratch, i can write '10 Jun 03' in the date textfield and sure enough, it will show on my asp page as '10/06/03' - and thats cool - great.

But when i need to update that fixture (like, to put in the score), I read in the details and in the date box, it reads '10/06/03' (which you would still think is ok BUT, when i update it this time, it goes in as '06/10/03' US style -aaarrrgghhh!!! - Its doing my head in!
(incidentally, at this point, should i have to update it again, it would read it in as '06/10/03' this time and when entered again, it would sort itself back to the correct intended '10/06/03')

Ive scoured the net for a solution to fit but, cant find one (there are loads of solutions if the date is simply "Now()" but, its not! in this instance :(

Other solutions ive tried are the LCID route but, that didn't work either! I was ready for making the field text only but, i cant coz i need the entire fixture list to be sorted by date aaarrrggghhh!

Please help

thanks

RedK

Thanks for replying :)

Changing the format within Access is irrelevant as it simply stores the date as a number anyway (days since 01/01/1899 or similar) So the date in access is like "36457" for 10th June 03 kinda thing no matter whether you want it as 10/06/03 or 06/10/03 - Access will have it as 36457!

The LCID is definitely set correctly - Ive got it in global.asa AND in each file just to be sure :(

Anyone any other ideas please?

thanks

Red..

Yes - Im entering it through a web form.

e.g - I enter 09/Aug/03 into the form and it goes into Access as 09/08/03 - thats great. When i try to update this fixture (through another webform) it firstly, reads its value back in as 09/08/03 (instead of 09/Aug/03) and this is where my problem is. Because this time, when i enter it, (and dont ammend it) it goes in as 08/09/03 automatically - see whats happening now?

Its driving me nuts my friend - any help most appreciated :)

Red..

I think I'd hit it the hard way...

in the meta tags for the new and the update pages, specify the charset

Use the corresdponding codepage (server.codepage=) in the asp page for the new and update pages, and in the formhandler pages for each one.

If it doesn't work, I'm going back under my rock.