[Sheila D]

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

[Peter Jamieson]

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" wrote in message
...
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

[Sheila D]

works a treat Peter, thanks.

Sheila
"Peter Jamieson" wrote:

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" wrote in message
...
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