| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement,microsoft.public.word.mailmerge.fields,microsoft.public.word.programming,microsoft.public.word.vba.general
|
|||
|
|||
UK Date bug in Word XP - Anyone know a fix?
I have a mail merge connected to a a database & M.S word (XP) displays
'some' dates in U.S. date format (m/d/y) instead of UK (d/m/y) - obviously i cant use these for professional mail-shots as i'd intended No formatting can cure this and apparently it's a bug - this is a company machine and the chances of an upgrade will be at best next year meanwhile - anyone know any fix/work around for this - i'm not above a vba fix if ness |
|
#2
Posted to microsoft.public.word.docmanagement,microsoft.public.word.mailmerge.fields,microsoft.public.word.programming,microsoft.public.word.vba.general
|
|||
|
|||
|
UK Date bug in Word XP - Anyone know a fix?
See http://www.gmayor.com/formatting_word_fields.htm
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "JethroUK©" wrote in message ... I have a mail merge connected to a a database & M.S word (XP) displays 'some' dates in U.S. date format (m/d/y) instead of UK (d/m/y) - obviously i cant use these for professional mail-shots as i'd intended No formatting can cure this and apparently it's a bug - this is a company machine and the chances of an upgrade will be at best next year meanwhile - anyone know any fix/work around for this - i'm not above a vba fix if ness |
|
#3
Posted to microsoft.public.word.docmanagement,microsoft.public.word.mailmerge.fields,microsoft.public.word.programming,microsoft.public.word.vba.general
|
|||
|
|||
|
UK Date bug in Word XP - Anyone know a fix?
as i mentioned - Word 2002 can't format UK dates - it's a documented bug -
i'm actually looking for a fix to this, so i can use it professionally anyone know anything about this? - and maybe a fix "Suzanne S. Barnhill" wrote in message ... See http://www.gmayor.com/formatting_word_fields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "JethroUK©" wrote in message ... I have a mail merge connected to a a database & M.S word (XP) displays 'some' dates in U.S. date format (m/d/y) instead of UK (d/m/y) - obviously i cant use these for professional mail-shots as i'd intended No formatting can cure this and apparently it's a bug - this is a company machine and the chances of an upgrade will be at best next year meanwhile - anyone know any fix/work around for this - i'm not above a vba fix if ness |
|
#4
Posted to microsoft.public.word.docmanagement,microsoft.public.word.mailmerge.fields,microsoft.public.word.programming,microsoft.public.word.vba.general
|
|||
|
|||
|
UK Date bug in Word XP - Anyone know a fix?
If you apply a formatting switch, the date will be displayed as you desired;
see http://word.mvps.org/FAQs/TblsFldsFms/DateFields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "JethroUK©" wrote in message ... as i mentioned - Word 2002 can't format UK dates - it's a documented bug - i'm actually looking for a fix to this, so i can use it professionally anyone know anything about this? - and maybe a fix "Suzanne S. Barnhill" wrote in message ... See http://www.gmayor.com/formatting_word_fields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "JethroUK©" wrote in message ... I have a mail merge connected to a a database & M.S word (XP) displays 'some' dates in U.S. date format (m/d/y) instead of UK (d/m/y) - obviously i cant use these for professional mail-shots as i'd intended No formatting can cure this and apparently it's a bug - this is a company machine and the chances of an upgrade will be at best next year meanwhile - anyone know any fix/work around for this - i'm not above a vba fix if ness |
|
#5
Posted to microsoft.public.word.docmanagement,microsoft.public.word.mailmerge.fields,microsoft.public.word.programming,microsoft.public.word.vba.general
|
|||
|
|||
|
UK Date bug in Word XP - Anyone know a fix?
it wont i'm afraid - it's a documented bug with Word XP 2002 (suprised you
dont know about it) - there's a fix for this in sp3 but i dont anticipate an upgrade for a year "Suzanne S. Barnhill" wrote in message ... If you apply a formatting switch, the date will be displayed as you desired; see http://word.mvps.org/FAQs/TblsFldsFms/DateFields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "JethroUK©" wrote in message ... as i mentioned - Word 2002 can't format UK dates - it's a documented bug - i'm actually looking for a fix to this, so i can use it professionally anyone know anything about this? - and maybe a fix "Suzanne S. Barnhill" wrote in message ... See http://www.gmayor.com/formatting_word_fields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "JethroUK©" wrote in message ... I have a mail merge connected to a a database & M.S word (XP) displays 'some' dates in U.S. date format (m/d/y) instead of UK (d/m/y) - obviously i cant use these for professional mail-shots as i'd intended No formatting can cure this and apparently it's a bug - this is a company machine and the chances of an upgrade will be at best next year meanwhile - anyone know any fix/work around for this - i'm not above a vba fix if ness |
|
#6
Posted to microsoft.public.word.docmanagement,microsoft.public.word.mailmerge.fields,microsoft.public.word.programming,microsoft.public.word.vba.general
|
|||
|
|||
|
UK Date bug in Word XP - Anyone know a fix?
If you are using Access as the datasource, I would create a query that made
use of the format() function the force the date into the desired format. Otherwise, See the "Dates: day/month reversed" item under the "Connection methods" topic of the "Mail merge in Word 2002" section of fellow MVP Cindy Meister's website at: http://homepage.swissonline.ch/cindy...r/MergFram.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JethroUK©" wrote in message ... it wont i'm afraid - it's a documented bug with Word XP 2002 (suprised you dont know about it) - there's a fix for this in sp3 but i dont anticipate an upgrade for a year "Suzanne S. Barnhill" wrote in message ... If you apply a formatting switch, the date will be displayed as you desired; see http://word.mvps.org/FAQs/TblsFldsFms/DateFields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "JethroUK©" wrote in message ... as i mentioned - Word 2002 can't format UK dates - it's a documented bug - i'm actually looking for a fix to this, so i can use it professionally anyone know anything about this? - and maybe a fix "Suzanne S. Barnhill" wrote in message ... See http://www.gmayor.com/formatting_word_fields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "JethroUK©" wrote in message ... I have a mail merge connected to a a database & M.S word (XP) displays 'some' dates in U.S. date format (m/d/y) instead of UK (d/m/y) - obviously i cant use these for professional mail-shots as i'd intended No formatting can cure this and apparently it's a bug - this is a company machine and the chances of an upgrade will be at best next year meanwhile - anyone know any fix/work around for this - i'm not above a vba fix if ness |
|
#7
Posted to microsoft.public.word.docmanagement,microsoft.public.word.mailmerge.fields,microsoft.public.word.programming,microsoft.public.word.vba.general
|
|||
|
|||
|
UK Date bug in Word XP - Anyone know a fix?
Hi JethroUK©,
as i mentioned - Word 2002 can't format UK dates - it's a documented bug - i'm actually looking for a fix to this, so i can use it professionally anyone know anything about this? - and maybe a fix Did you actually read through the information on Graham's site? Or read his last reply to you? Most of the information as to workarounds is there (as in use a DDE or ODBC connection). You'll also find information (in a denser format) on my site, in the Word 2002/2003 section. A fix was issued in one of the more recent Service Packs (SP), probably SP2. It's also fixed in Word 2003. And by "fix" I mean that the day/month information doesn't get switched around "by whim", but is passed across consistently. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
|
#8
Posted to microsoft.public.word.docmanagement,microsoft.public.word.mailmerge.fields,microsoft.public.word.programming,microsoft.public.word.vba.general
|
|||
|
|||
|
UK Date bug in Word XP - Anyone know a fix?
I dont think the query formatting is an option for me because i imagine this
would affect the input format on the form (appointment date & time) Graham Mayor suggested connecting as DDE via connection options - and this seems to have fix it good news is that Word connected this way automatically even after taking the tick out "Doug Robbins - Word MVP" wrote in message ... If you are using Access as the datasource, I would create a query that made use of the format() function the force the date into the desired format. Otherwise, See the "Dates: day/month reversed" item under the "Connection methods" topic of the "Mail merge in Word 2002" section of fellow MVP Cindy Meister's website at: http://homepage.swissonline.ch/cindy...r/MergFram.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JethroUK©" wrote in message ... it wont i'm afraid - it's a documented bug with Word XP 2002 (suprised you dont know about it) - there's a fix for this in sp3 but i dont anticipate an upgrade for a year "Suzanne S. Barnhill" wrote in message ... If you apply a formatting switch, the date will be displayed as you desired; see http://word.mvps.org/FAQs/TblsFldsFms/DateFields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "JethroUK©" wrote in message ... as i mentioned - Word 2002 can't format UK dates - it's a documented bug - i'm actually looking for a fix to this, so i can use it professionally anyone know anything about this? - and maybe a fix "Suzanne S. Barnhill" wrote in message ... See http://www.gmayor.com/formatting_word_fields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "JethroUK©" wrote in message ... I have a mail merge connected to a a database & M.S word (XP) displays 'some' dates in U.S. date format (m/d/y) instead of UK (d/m/y) - obviously i cant use these for professional mail-shots as i'd intended No formatting can cure this and apparently it's a bug - this is a company machine and the chances of an upgrade will be at best next year meanwhile - anyone know any fix/work around for this - i'm not above a vba fix if ness |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hard space between words. | Microsoft Word Help | |||
| How can Word display full path of a file in the title bar? | Microsoft Word Help | |||
| Does Word have a QuickCorrect/Quick Word option like WordPerfect? | New Users | |||
| In Word, how do I surpress headers and footers on page 2 | Microsoft Word Help | |||
| Envelope Address | New Users | |||
Linear Mode
