displaying dates in a form and table

  • Thread starter Thread starter Gabriella777_2
  • Start date Start date
G

Gabriella777_2

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?
 
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.
 
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.
 
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
 
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?
 
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?
 
Thank you - for your response - please see Mr. Steele's answer/reply and my
following question.
 
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.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Gabriella777_2 said:
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?
Click to expand...
 
Back
Top