Long date default for data entry to 2009

  • Thread starter Thread starter Pat Hughes
  • Start date Start date
P

Pat Hughes

I want to set the default for my table to be 2009 for my long date in the
entry form so that when the user enters the data they won't make a mistake
and enter 2008 or whatever. In fact they wouldn't even have to enter the
year. I just can't figure out how to put it in as the default. It seems
like it should be so easy. I don't want them to be able to change it.

Thanks
 
Thanks but I don't know code. I just thought that their might be an easier
solution in the default value or validation rule. I don't understand what
you are saying about "Try entering 2/3 in a textbox bound to a date field.
If you don't have an
input mask that disallows it, you'll get 02/03/2009. Users can explcitly type
a year, but if they don't it will be fine. " But anyway the field already has to be in the format of 02/03/2009. I just wanted to know if there is a way in the design of the table to make the default of the year to always be 2009 and where you can't change it.
Click to expand...

THanks.
 
Thanks but I don't know code. I just thought that their might be an easier
solution in the default value or validation rule. I don't understand what
you are saying about "Try entering 2/3 in a textbox bound to a date field.
Click to expand...

If you type a date without typing the year, Access will automatically assume
the current year. Again... *try it*. Open a form (or a table datasheet for
that matter). Type

2/3

in a date/time field. See what gets inserted.
 
Back
Top