I've created a fairly simple relational contacts/appointments database in Access 2000. I have set up a search facility that finds appointments by specifying a range of dates in two text boxes and then using code to apply the search as a filter to the data (which is on a subform). The actual dates and the format of the filter string are all correct, but when I checked the filter by form button to see what filter had been applied to the form, I found that the date format had been changed from the UK dd/mm/yyyy style to the US mm/dd/yyyy style.

I have checked regional settings and the keyboard layout in windows and they both apply to the UK (inc. the correct date format). I have even tried applying a set format string to all the individual date fields involved but still I'm having no joy.

Any ideas?
Thanks

I just tried to find the post without any success, but in a recent post someone had similar problems. If memory serves, the reply to the problem mentioned that Access, when running queries, filters, etc. only "deals" with dates in US format. I think you might be running into a similar problem. So, unfortunately, I think the answer to your question is that this is just how Access works. I could be WAY off base though.

I'll keep nosing around for the post and if I find it, I'll post it for you.

js

Now I don't know... here's some posts I found... maybe they'll be helpful
http://www.access-programmers.co.uk/ubb/Forum1/HTML/002199.html
http://www.access-programmers.co.uk/ubb/Forum7/HTML/001213.html

js

PS-Sorry. http://www.access-programmers.co.uk/ubb/frown.gif

Thanks for your help.

Just in case anyone else is having the same problem, I found another way round the problem is to format the date(s) as dd/mmm/yyyy.

This forces Access to put the month the right way round as the month is displayed as text and thus cannot be switched to day.