displaying dates in a form and table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gabriella777_2 - 04 Mar 2008 22:36 GMT

I have tried every thing I can find so far to set the date to display both on
the form and in the table as dd/mm/yy even when it wants to display as
d/m/yyyy.
I need to be able to sort by date for reports and queries so I don't want to
use the text option.
Can someone please help?

Signature

Thanks and God bless you and yours,
Gabriella777_2

Reply to this Message

KARL DEWEY - 05 Mar 2008 00:19 GMT

Open the form in design view, click on the textbox that dispays the date,
click on menu VIEW - Properties. In the Format enter d/m/yy. Save.

Signature

KARL DEWEY
Build a little - Test a little

> I have tried every thing I can find so far to set the date to display both on
> the form and in the table as dd/mm/yy even when it wants to display as
> d/m/yyyy.
> I need to be able to sort by date for reports and queries so I don't want to
> use the text option.
> Can someone please help?

Reply to this Message

KARL DEWEY - 05 Mar 2008 00:22 GMT

Did not read correctly --
In the Format enter d/m/yyyy. Save.

How it displays in table should not matter to anyone as the table should not
be used for viewing.

Signature

KARL DEWEY
Build a little - Test a little

> Open the form in design view, click on the textbox that dispays the date,
> click on menu VIEW - Properties. In the Format enter d/m/yy. Save.
[quoted text clipped - 5 lines]
> > use the text option.
> > Can someone please help?

Reply to this Message

Gabriella777_2 - 05 Mar 2008 14:49 GMT

Good Morning Mr. Dewey and anyone who responds to this e-mail.
Thank you for your help. However, I guess I did not make myself
understandable.
What I am attempting to do per the request of the gentleman with whom I am
working on this project is to get the date to display in any view (table,
form, report, etc) as dd/mm/yy - 2 digits on both sides of the slash.
He prefers to read the date of say February 2, 2008 as 02/02/08 rather than
2/2/08 or 2/2/2008.

Thanks and God bless you and yours,
Gabriella777_2

> Did not read correctly --
> In the Format enter d/m/yyyy. Save.
[quoted text clipped - 11 lines]
> > > use the text option.
> > > Can someone please help?

Reply to this Message

KARL DEWEY - 05 Mar 2008 15:48 GMT

The display must be set in each place separately - every form and report.

Signature

KARL DEWEY
Build a little - Test a little

> Good Morning Mr. Dewey and anyone who responds to this e-mail.
> Thank you for your help. However, I guess I did not make myself
[quoted text clipped - 23 lines]
> > > > use the text option.
> > > > Can someone please help?

Reply to this Message

Gabriella777_2 - 05 Mar 2008 16:55 GMT

Thank you - for your response - please see Mr. Steele's answer/reply and my
following question.

Signature

Thanks and God bless you and yours,
Gabriella777_2

> The display must be set in each place separately - every form and report.
>
[quoted text clipped - 25 lines]
> > > > > use the text option.
> > > > > Can someone please help?

Reply to this Message

Douglas J. Steele - 05 Mar 2008 15:52 GMT

Karl's point is that no one should be working directly with tables or
queries. All input should be done through forms. All output should be done
through reports.

What is the individual's Short Date format set to through Regional Settings
in the Control Panel?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Good Morning Mr. Dewey and anyone who responds to this e-mail.
> Thank you for your help. However, I guess I did not make myself
[quoted text clipped - 29 lines]
>> > > use the text option.
>> > > Can someone please help?

Reply to this Message

Gabriella777_2 - 05 Mar 2008 16:53 GMT

Okay, so what I am hearing is that I cannot format the date in the design
view of the table and expect it to display as I choose it, it must be set on
each individual computer's control panel. Correct?

Signature

Thanks and God bless you and yours,
Gabriella777_2

> Karl's point is that no one should be working directly with tables or
> queries. All input should be done through forms. All output should be done
[quoted text clipped - 36 lines]
> >> > > use the text option.
> >> > > Can someone please help?

Reply to this Message

Douglas J. Steele - 05 Mar 2008 18:10 GMT

No, I'm saying that Access uses whatever's defined in Regional Settings as
its default date format.

Setting a format at the table level usually works to override the default,
but sometimes it is necessary to explicitly set the format for each text box
that will contain the date on each form and report.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Okay, so what I am hearing is that I cannot format the date in the design
> view of the table and expect it to display as I choose it, it must be set
[quoted text clipped - 50 lines]
>> >> > > use the text option.
>> >> > > Can someone please help?

Reply to this Message

Gabriella777_2 - 05 Mar 2008 19:09 GMT

Gotcha - thank you.

Signature

Thanks and God bless you and yours,
Gabriella777_2

> No, I'm saying that Access uses whatever's defined in Regional Settings as
> its default date format.
[quoted text clipped - 57 lines]
> >> >> > > use the text option.
> >> >> > > Can someone please help?

Reply to this Message