Formatting fields.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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>

Lee said:
I would like to know if there is a way to format a date field. For
Click to expand...
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.
 
Back
Top