Medium Date format and calendar in Access 2007

Hi there

Due to complaints from users, I will have to use medium date format for
dates instead of Short Date in my forms. The Tables are in the short date
format. So the data tables are Short Date and the Forms are Medium Date.

When I changed the format of dates from Short date to medium date in my
form, the calendar is no longer available for me to select dates.

Essentially the users want to use the calendar to select the date but on the
form they want to see the format as dd-mmm-yyyy.

The users do not want to change their computer settings to the dd-mmm-yyyy
and would rather have access 2007 to do it instead.

Thank you in advance for your help.

On Mon, 22 Mar 2010 21:54:01 -0700, forest8
wrote:

Hi there

Due to complaints from users, I will have to use medium date format for
dates instead of Short Date in my forms. The Tables are in the short date
format. So the data tables are Short Date and the Forms are Medium Date.

You're misunderstanding how dates are stored. The format is NOTHING but a
display property. The date is actually stored as a Double Float number, a
count of days and fractions of a day since midnight, December 30, 1899. No
format is stored in the table.

When I changed the format of dates from Short date to medium date in my
form, the calendar is no longer available for me to select dates.

Something else changed then.

Essentially the users want to use the calendar to select the date but on the
form they want to see the format as dd-mmm-yyyy.

The users do not want to change their computer settings to the dd-mmm-yyyy
and would rather have access 2007 to do it instead.

Setting the Format property of a textbox bound to a date/time field to

"dd-mmm-yyyy"

should give you what you want.
--

John W. Vinson [MVP]