Date formats

  • Thread starter Thread starter H. Martins
  • Start date Start date
H

H. Martins

We use (sometimes) date formats as "2008.04.21"

Using "yyyy\.mm\.dd" data can be displayed in the required format.

Anyway, "2008-04-20"1 should be input (keyboard), unless opsys
Language and Regional Options is set to "."

As date format can be set differently from computer to computer, is
there a way to make Access (2003) accept "." type separators even
having different setup under Language and Regional Options?

Thanks
Henrique
 
Having had a similar problem (our format is dd/mmm/yyyy but some users try to
use the decimal point) the best solution that I found was to use the key press
event to translate the character:

If KeyAscii = 46 Then KeyAscii = 45

will change all dots into hyphens.

HTH
John
##################################
Don't Print - Save trees
 
Back
Top