Date question

[Rmaster]

If your regional language options set as English (united states) the date wil de showen as M/d/yyyy, but i want to see dd/mm/yyyy. Is This possible and if so how?

I've format my table also to dd/mm/yyyy
And the fields of my form als to dd/mm/yyyy

But the date still show M/d/yyyy and if you select the date then is is showen as dd/mm/yyyy but if you unselect it it go back to M/d/yyyy

 

[on-2]

windows itself needs to be set to english (england) settings not just access i think

 

[Mile-O]

Format is only for displayed at whatever level you've set the formatting on. If you set the format in the table then that formatting is for the table. If you set format in a query then tha formatting is only used in the query. Likewise with controls on forms and reports.

 

[Rmaster]

okey guys thanx for the information