Date Format

[Hellfire]

Hi All,

At the moment, I have my Date setting in Windows set to mm/dd/yyyy, this is the only way that Access seems to be putting TODAYS date againste a record created today.

I want this to be dd/mm/yyyy Where do I have to go in Access to ensure that it works?

I have tried the input mask, but that doesn't seem to have any effect.

Thanks
H

 

[Ally]

I'm pretty sure you will need to reset your Windows settings to English (British) and not English (United States) as Access will always revert to the Windows settings.

 

[Thedon123]

put the dd/mm/yyyy in the format section of the fieelds attributes