Formatting Date

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

Guest

I have seen a date field in a form actually displaying the / / when the field is empty and the entering of the digits in a date go either side of the / / correctly. How do they do that

Also, if I the load Now into that same field using a command button what format issues are raised if any? [I don't need the time - just the date]
 
I have seen a date field in a form actually displaying the / / when the
field is empty and the entering of the digits in a date go either side > of
the / / correctly. How do they do that?

That is done with an Input Mask.
Also, if I the load Now into that same field using a command button what
format issues are raised if any? [I don't need the time - just > > the date]

If you only need the date value, load Date()


--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Jason said:
I have seen a date field in a form actually displaying the / / when the
field is empty and the entering of the digits in a date go either side of
the / / correctly. How do they do that?
Also, if I the load Now into that same field using a command button what
format issues are raised if any? [I don't need the time - just the date]
 
Back
Top