Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Publisher

LinkBack Thread Tools Display Modes
Old 09-23-2011, 03:59 AM
Jazz43 Jazz43 is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
Join Date: Oct 2009
Posts: 51
Jazz43 is on a distinguished road
Default Publisher Catalog Merge - Long Date

I have a .pub which catalog merges from a MS Access database.

The catalog merges a date type field which is formatted within the database to show in long format e.g. 23 September 2011 and displays fine within the database table and queries.

My problem is that when the data is merged into the .pub it reformats it into a short date format of mm/dd/yyyy.

Is there any way to stop this, I have trawled for solutions but to no avail, the closest thing I could find would be a work-around to convert the date field within the database to a text field, but if possible would prefer not to do this.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Publisher 2010 only merging first page in multi-page catalog merge non-profit-girl Publisher 0 08-25-2011 06:55 PM
Mail merge picture into Publisher from URL BlueSprint Publisher 1 07-31-2011 03:06 PM
Publisher Merge sussertown Publisher 0 06-08-2011 03:38 PM
Wine List, Data Merge - Excel to Publisher - Or other suggestions? daym Publisher 2 05-01-2011 03:45 AM
Publisher Catalog Merge monkey7759 Publisher 1 01-29-2010 04:53 PM

All times are GMT -7. The time now is 04:22 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft