Display records in date order, form view

I'm very new to Access--self taught using Access Inside Out, Access for
Dummies, and trial and error.
Just created a simple database (form and table) for interlibrary loans. My
supervisor would like to see the most recent record when she opens the
program and click backwards. In form view, I right-clicked on the "borrowed
date" field, which uses "Short Date Input Mask" (99/99/0000;0) (mm/dd/yyyy);
and chose "sort ascending." Two stumbling blocks:
1. This works for most, but 12/06/2004 comes after 12/02/2005--apparently
the sorting is purely numerical. Can that be changed without putting dates
in yyyy/mm/dd format?
Thanks
2. How can I set it so that it opens to the last record instead of the first?
Also, it would be a bonus if we could enter years with two digits (so that
they appear as four digits. Our invoice database does that, but this new one
(and the other one I created for our catalog) doesn't.

Answered some of my own questions:
1. In Table design view, my date fields were in text format: when I switched
them to date format the 12/02/2005, 12/06/2004 problem went away.
2. In forms design view, I clicked the black square at the top left, and
under "on open" I chose "add record." Better than opening to the oldest
record.
Still don't know about the two digit year question, but that's unimportant.


"ReadReadWrite" wrote:

I'm very new to Access--self taught using Access Inside Out, Access for
Dummies, and trial and error.
Just created a simple database (form and table) for interlibrary loans. My
supervisor would like to see the most recent record when she opens the
program and click backwards. In form view, I right-clicked on the "borrowed
date" field, which uses "Short Date Input Mask" (99/99/0000;0) (mm/dd/yyyy);
and chose "sort ascending." Two stumbling blocks:
1. This works for most, but 12/06/2004 comes after 12/02/2005--apparently
the sorting is purely numerical. Can that be changed without putting dates
in yyyy/mm/dd format?
Thanks
2. How can I set it so that it opens to the last record instead of the first?
Also, it would be a bonus if we could enter years with two digits (so that
they appear as four digits. Our invoice database does that, but this new one
(and the other one I created for our catalog) doesn't.

1. It sounds like your field is DataType - Text instead of DataType -
DateTime.
Format is just the display and should not affect sorting.

2. You can add an Event/Macro to the form - On Open property to GoToRecord -
New. If you go to LAST it will go to the end of file but may not be the
last record entered.


"ReadReadWrite" wrote:

Answered some of my own questions:
1. In Table design view, my date fields were in text format: when I switched
them to date format the 12/02/2005, 12/06/2004 problem went away.
2. In forms design view, I clicked the black square at the top left, and
under "on open" I chose "add record." Better than opening to the oldest
record.
Still don't know about the two digit year question, but that's unimportant.


"ReadReadWrite" wrote:

I'm very new to Access--self taught using Access Inside Out, Access for
Dummies, and trial and error.
Just created a simple database (form and table) for interlibrary loans. My
supervisor would like to see the most recent record when she opens the
program and click backwards. In form view, I right-clicked on the "borrowed
date" field, which uses "Short Date Input Mask" (99/99/0000;0) (mm/dd/yyyy);
and chose "sort ascending." Two stumbling blocks:
1. This works for most, but 12/06/2004 comes after 12/02/2005--apparently
the sorting is purely numerical. Can that be changed without putting dates
in yyyy/mm/dd format?
Thanks
2. How can I set it so that it opens to the last record instead of the first?
Also, it would be a bonus if we could enter years with two digits (so that
they appear as four digits. Our invoice database does that, but this new one
(and the other one I created for our catalog) doesn't.