First Capital field formatting Sheila D 5/18/2007 2:33:01 PM Can anybody tell me why when my data is in capitals in the data source the First Capital field format has no effect? I've tried using data from Word table and Excel spreadsheet and both have the same problem. If I change the data to lower case in the source then I can use the Frist Capital format. Not causing me a major problem but seems a little bizarre.... I'm formatting just by using right mouse, Edit Field then choosing format and using Word 2003. Thanks for any help Sheila

Re: First Capital field formatting "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 5/18/2007 2:47:09 PM I don't know /why/ it's like that, but with any luck you may be able to use { MERGEFIELD myfield \*lower \*firstcap } to do what you need. Peter Jamieson "Sheila D" <SheilaD[ at ]discussions.microsoft.com> wrote in message news:5AFF3341-AAC0-472E-94CF-00C92C6C6355[ at ]microsoft.com... [Quoted Text] > Can anybody tell me why when my data is in capitals in the data source the > First Capital field format has no effect? I've tried using data from Word > table and Excel spreadsheet and both have the same problem. If I change > the > data to lower case in the source then I can use the Frist Capital format. > Not > causing me a major problem but seems a little bizarre.... I'm formatting > just > by using right mouse, Edit Field then choosing format and using Word 2003. > Thanks for any help > Sheila

Re: First Capital field formatting Sheila D 5/18/2007 2:58:00 PM works a treat Peter, thanks. Sheila "Peter Jamieson" wrote: [Quoted Text] > I don't know /why/ it's like that, but with any luck you may be able to use > > { MERGEFIELD myfield \*lower \*firstcap } > > to do what you need. > > Peter Jamieson > "Sheila D" <SheilaD[ at ]discussions.microsoft.com> wrote in message > news:5AFF3341-AAC0-472E-94CF-00C92C6C6355[ at ]microsoft.com... > > Can anybody tell me why when my data is in capitals in the data source the > > First Capital field format has no effect? I've tried using data from Word > > table and Excel spreadsheet and both have the same problem. If I change > > the > > data to lower case in the source then I can use the Frist Capital format. > > Not > > causing me a major problem but seems a little bizarre.... I'm formatting > > just > > by using right mouse, Edit Field then choosing format and using Word 2003. > > Thanks for any help > > Sheila >