date format access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

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

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


 

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips


Server loaded in 0.11 secs.