date format on form (2007)

Topic

New Reply

I have a date picking form for setting the date range for reports on a client’s database. They are using Access 2007 but the database format is 2000. On the workstation I was using yesterday to install some updated reports, I noticed the date picker was displaying dates as yy-mm-dd even though the textbox specifies medium date. I checked regional settings and they are correct. Besides, they don’t handle medium date format anyways. As far as I know, it is just the one workstation. Any ideas where to look?

Reply | Quote

Replies

I have no idea what causes this, but try specifying the date format explicitly as dd-mmm-yyyy instead of as Medium Date.

Reply | Quote

Thanks Hans. I don’t really want to go to that trouble as it seems to be only the one workstation and the code in the on click event gets modified quite regularly. If it does appear to be a problem on others, I will follow your advice. I’m sure this user has some weird setting somewhere that is causing this and I wouldn’t be at all surprised if it is somewhere in the bowels of Access 2007.

Thanks

Reply | Quote

I am also having problems with the date picker in my Access 2007 database. All of a sudden the dates do not display correctly.

At the table level and at the form level I specified the date format as dd-mmm-yyyy, as suggested (the format was “Medium Date”). The dates DO display in that format, but backwards. For example, if I was to pick 5 July 2009 from the date picker, the format would be correct, but the date would display as 7 May 2009.

Since this is a new bug that somehow introduced itself into the DB, I did a compact and repair on both the front and back ends, but that didn’t work.

Any ideas on what I might try next?

Thanks,

JoeK

Reply | Quote

I don’t think compacting the database would help here. It appears there’s confusion between US and European date formats. How do you process the date selected by the user?

Reply | Quote

I don’t think compacting the database would help here. It appears there’s confusion between US and European date formats. How do you process the date selected by the user?

I am not sure what you mean by “process the date”. The date is stored in a bound field – is that what you mean?

BTW, when you mentioned US and European date formats, it reminded me to check the regional settings on my PC. Lo and behold, I had the US format set as the date format. I changed it to dd-MMM-yyyy and now the dates in my DB work the way I want them to.

I would have thought that you would be able to override the PC’s regional settings because multiple users have different settings and I can’t ask them all to change their own preferences. I did make sure that the field format is dd-MMM-yyyy, but that didn’t seem to help at all.

If I type the date directly into the field, I don’t have any problems. Maybe it’s just the way the date-picker works…Maybe I have to use a customized date-picker and not the built in one…?

Reply | Quote

Do you mean that the Date/Time Picker control is bound directly to a field? If so, the problem might be specific to Access 2007, but I don’t use that version so I know very little about it.

Reply | Quote

I am also having problems with the date picker in my Access 2007 database. All of a sudden the dates do not display correctly.

At the table level and at the form level I specified the date format as dd-mmm-yyyy, as suggested (the format was “Medium Date”). The dates DO display in that format, but backwards. For example, if I was to pick 5 July 2009 from the date picker, the format would be correct, but the date would display as 7 May 2009.

Since this is a new bug that somehow introduced itself into the DB, I did a compact and repair on both the front and back ends, but that didn’t work.

Any ideas on what I might try next?

Thanks,

JoeK

1. What’s your Windows regional setting?
2. Has you set the Input Mask for the date field (table)?
3. If you set Default Value to Date() or Now(), does it display correctly?
4. Is Hebrew used as the default language?

Armstrong

Reply | Quote

I have a date picking form for setting the date range for reports on a client’s database. They are using Access 2007 but the database format is 2000. On the workstation I was using yesterday to install some updated reports, I noticed the date picker was displaying dates as yy-mm-dd even though the textbox specifies medium date. I checked regional settings and they are correct. Besides, they don’t handle medium date format anyways. As far as I know, it is just the one workstation. Any ideas where to look?

Hi Peter,
Is it SP2 of Access 2007 (12.0.6423.1000)?
Armstrong

Reply | Quote