Date formats

[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

 

[John Smith]

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