Prev: Calculated a field in a subform.
Next: Looking up 2 combo boxes and then calculate another field
From: forest8 on 23 Mar 2010 00:54
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.
From: John W. Vinson on 23 Mar 2010 01:11
On Mon, 22 Mar 2010 21:54:01 -0700, forest8
<forest8(a)discussions.microsoft.com> 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]
 | 
Pages: 1
Prev: Calculated a field in a subform.
Next: Looking up 2 combo boxes and then calculate another field