Need Date Field to just should MM YY

[Bill]

Hi All,

I need a date field to just show the Month and Year. I'm not precious about
the exact format but the problem is that I have entered information into a
text field as just (for example) June 2009, but I now need to do comparisons
based on that field which I had not foreseen at the outset.

Is there anyway to display a date as I need please.

Ta.
Bill.

 

[Rick Brandt]

Hi All,

I need a date field to just show the Month and Year. I'm not precious
about the exact format but the problem is that I have entered
information into a text field as just (for example) June 2009, but I now
need to do comparisons based on that field which I had not foreseen at
the outset.

Is there anyway to display a date as I need please.

Ta.
Bill.

You can use the format property on TextBoxes to *display* a date any way
you like, but you must *store* a full date (year, month, day, hour,
minute, and second).

In most cases if you don't supply all values during data entry some
defaults are assumed. For example not entering any time will give you a
default of midnight. Not entering a year will (I think) default to the
current year. Not entering the day will default to the first of the
month.

Of course if you are entering numeric values and don't supply all of them
then Access will decide whether the number you omitted was the day, the
month, or the year, and that decision might not be what you intended.