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

date format access

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

Date format in Access

ResolvedVersion 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:

Combo box for finding records

You can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.