Formatting fields.

[Guest]

I would like to know if there is a way to format a date field. For example, if there is a column where you have this date format: 09/5/03. Is there are way to just type in the numbers and have them automatically default to 08/07/04.

If someone knows a way to do the above, I would greatly appreciate his or her input

Thanks in advance

 

[Ken Snell]

Use an input mask for the field. That will let your user type just numbers
without dashes or slashes.
Then set the format of the field to "mm/dd/yy".


--
Ken Snell
<MS ACCESS MVP>

I would like to know if there is a way to format a date field. For

example, if there is a column where you have this date format: 09/5/03. Is
there are way to just type in the numbers and have them automatically
default to 08/07/04.