Date problem

[Blueraven]

Hi,
I have a command button on my form which simply adds date to another text box via now() but it used to work fine, now all of a sudden from start of the year it is puting thedate in US format, ie. mm/dd/yr any idea what has happened and how I can get it back to dd/mm/yr ????

Thanks

 

[ccox]

I'm not sure if this will help or not but I've formatted dates using the following:
=Format(Date(),"dd/mm/yy")

 

[Blueraven]

Hi thanks for getting back but I cant get that to work either.
I've misled everyone a little I think, as I tried to ask my question from memory.

What I actually have is the command button macro has a setvalue with the expression to update the textbox of Date$() I've tried adding on the ,dd/mm/yy part like you have but it fails on syntax errors etc. This is probably so east to solve. I'll try to hunt through all the help pages but check back here in case someone knows.

 

[Bat17]

Dates are stored as numbers and just displayed in a text format. The date format should be controlled by the recieving text box. Check it's format property. If it is Short Date, then check the value in the control panel for the PC as Access dates normaly just reflect local settings.

HTH

Peter