UK/US Access Date headache

Hey,

Thanks everyone for their solutions - Ive finally got it sorted but, still feel ive went the long way about it.

What i did was, I made 3 new fields in my db (day, month & year) giving me them plus a date 'field'.
I then used dropdowns to select the dates instead. This way, i can be assured that its being entered as 10 Aug 03 and having those three extra fields allows it to be read back in the same way when im updating.

I then used two hidden fields that simply contain a forward slash "/" and the field called 'date' takes the info from [day, hidden1, month, hidden2, year] This way, when i disply the fixture list, i can simply request 'date' from the db and still have it written as the normal 10/06/03 :)

Thanks very much to everyone who went to the trouble of replying - It was really appreciated!!!!

Red..

oh, i intend to Bunce - Its been annoying me for too long to settle for the quick fix now hehehe! The problem has just been going on too long and i had to find a solution and move on. I will study what you gave me and go back at a later time and sort out the code'n.

thanks again :)

Red..