Problem With Calendar Control

[Harry F.]

Hello All,

I have a calendar control to govern a date field. When a date between the
first and twelfth of the month is selected the date always appears backwards
(ie. January 10 is displayed as 01-Oct-06 rather than 10-Jan-06, October 3 is
10-Mar-06, and so on). From the 12th to the end of the month, it displays
properly. Please help me!

Thanks in advance,
Harry

 

[Douglas J Steele]

What are you doing with the date when this happens? In other words, are you
using it in a query, are you displaying it in a text box, or what? How do
you transfer the date from the control to wherever you're using it?

Access almost always insists that dates be in mm/dd/yyyy format, or some
unambiguous format such as yyyy-mm-dd or dd mmm yyyy, regardless what you
may have set as the Short Date format in Regional Settings.

For more information about working with International Dates, see Allen
Browne's "International Dates in Access" at
http://allenbrowne.com/ser-36.html or what I had in my September 2003 Access
Answers column for Pinnacle Publication's "Smart Access" newsletter. (The
column and accompanying database can be downloaded for free at
http://www.accessmvp.com/djsteele/SmartAccess.html)

 

[Harry F.]

Doug,

Thanks for the response. The date is going into a text box. I probably
should have mentioned that the database is one used in Great Britain as well
as America, and the previous author had written code to try to fix the
problem. It never fixed it, I'm developing a new version, and it still makes
the error. Is there no way to have the date appear as dd-mmm-yy format
correctly?

Thanks,
Harry

 

[Douglas J. Steele]

Is the text box bound to the control, or do you have code that transfers the
date to the text box? If the latter, what's the code?

 

[Harry F.]

Doug,

I used Allen Browne's calendar form, and it has fixed my issue. Thanks for
your assistance.

Regards,
Harry