Date format problem

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I am trying to get a date format to work that shows the month and the year
only. I have an imput mask of: >L<LL\-00;0;_ which works fine untill i
hit the enter key. Example: MAR-04 changes to 3/4/2004. How do I prevent
this change. I need the form to show MAR-04 etc. This is probably an easy
fix...Thanks...Randy
 
I am trying to get a date format to work that shows the month and the year
only. I have an imput mask of: >L<LL\-00;0;_ which works fine untill i
hit the enter key. Example: MAR-04 changes to 3/4/2004. How do I prevent
this change. I need the form to show MAR-04 etc. This is probably an easy
fix...Thanks...Randy
Click to expand...

To point out to you how misleading your above Mar-04 is, is it March
4th, or March 2004 which you are attempting to display?

Remove the input mask.
Set the Format property to
mmm-yyyy

The date field will display as
Mar-2004
There will be no confusion as to what the entry is supposed to
represent.

Regardless of how you wish to display the date, it MUST be entered as
a valid date, i.e. it has a month, a day, and a year.

Enter dates into the field to include the month, the date, and the
year.
If the actual day doesn't matter, enter Mar 1.

If an incomplete date is entered, Access will assume you have entered
the month and day. It will default to the current year.
 
Thanks Fred, that helps...Randy
fredg said:
To point out to you how misleading your above Mar-04 is, is it March
4th, or March 2004 which you are attempting to display?

Remove the input mask.
Set the Format property to
mmm-yyyy

The date field will display as
Mar-2004
There will be no confusion as to what the entry is supposed to
represent.

Regardless of how you wish to display the date, it MUST be entered as
a valid date, i.e. it has a month, a day, and a year.

Enter dates into the field to include the month, the date, and the
year.
If the actual day doesn't matter, enter Mar 1.

If an incomplete date is entered, Access will assume you have entered
the month and day. It will default to the current year.
Click to expand...
 
Back
Top