Formatting Date

[Jason]

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]

 

[Cheryl Fischer]

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

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]