Input Mask and Adding Century Prefix for Year

[Guest]

Hi

How can you set a date field so that the user types in :
dd/mm/yy
and the result is automatically changed to
dd/mm/19yy or dd/mm/20yy
to reflect which century the date falls in, thus saving keystrokes? I've
seen this in an access database form but don't know how to code it.
I guess you'll have to "test" the entered year to determine whether it
should have 19 or 20 as a prefix, and then save this 4-digit year along with
the rest of the date in the underlying table.

Thanks
rich

 

[Guest]

Try this
In the input mask property of the field write
00/00/00

In the format property of the field write
dd/mm/yyyy

 

[Guest]

Thanx Ofer
easy when you know how

Try this
In the input mask property of the field write
00/00/00

In the format property of the field write
dd/mm/yyyy