date format access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Date format in Access

Date format in Access

resolvedResolved · Low Priority · Version Standard

replyReply Tue 4 Mar 2008, 14:06Delegate Nova said...

Nova has attended:
Access Intermediate course
Access Advanced course

Date format in Access

On my database the date format is set as English dd/mm/yy, although this appears right on the form and table, when the data is used and mail merged into a document , the date comes out in the American format mm/dd/yy. Help please

For upcoming training course dates see: Pricing & availability

replyReply Mon 17 Mar 2008, 08:43Trainer Pete said...

RE: Date format in Access

Hi Nova, Thank you for your post, Sorry been away for a while, in answer to your post:
1. In Word: Check out the language setting on your status bar, ensure that this is set to English UK, if this is not the case, double-click on the option shown (English US) and change your default settings to English UK.
2. If this does not resolve the problem then you will need to change your language settings in Office Setup:
3. On the Tools menu, click Options, and then click the Complex Scripts tab.
4. If you don

 

Please browse our web site to find out more about
microsoft access training class and other Microsoft training courses.

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard