date parts

I am designing a data base to track renovations – the user is not interested
in the date of a renovation – only the month and year – is there a way I can
store just the month and year in one date field, with the current month and
year as the default value?
TIA
Bibi

A date/time field must have a day. Perhaps you could use the first of the
month, and format it as mmm-yyyy.

You could put some code into the Load event of your form to set the Default
Value of a text box to DateSerial(Year(Date), Month(Date),1) or Date -
Day(Date) + 1.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bibi" wrote in message
...
I am designing a data base to track renovations – the user is not
interested
in the date of a renovation – only the month and year – is there a way I
can
store just the month and year in one date field, with the current month
and
year as the default value?
TIA
Bibi

Just store a whole data in a date/time type field. It is much easier that
way. You can also simplfy your world be stroring all dates as the first of
the month.

"Bibi" wrote in message
...
I am designing a data base to track renovations - the user is not
interested
in the date of a renovation - only the month and year - is there a way I
can
store just the month and year in one date field, with the current month
and
year as the default value?
TIA
Bibi

I'm leaning that way but is there a method where the user only sees the month
and date as a choice and/or the day part of the date is ALWAYS the 1st?
TIA
Bibi

"Klatuu" wrote:

Just store a whole data in a date/time type field. It is much easier that
way. You can also simplfy your world be stroring all dates as the first of
the month.

"Bibi" wrote in message
...
I am designing a data base to track renovations - the user is not
interested
in the date of a renovation - only the month and year - is there a way I
can
store just the month and year in one date field, with the current month
and
year as the default value?
TIA
Bibi

On Thu, 18 Sep 2008 15:34:10 -0700, Bibi
wrote:

I'm leaning that way but is there a method where the user only sees the month
and date as a choice and/or the day part of the date is ALWAYS the 1st?

You could store the full date (with the first of the month) and use a form
control with a Format property like "mmmm yyyy" to show "September 2008".

If you are using a combo box to select the date, just base it on a (manually
filled) table with one datefield per month.
--

John W. Vinson [MVP]