[PaddyWack]

I have a project that I maintain for a client.

It uses Word merge documents that have dynamic text based on user
input.

The problem is that when merge fields are formatted as currency and the
dynamic text moves the fields to the right margin, the "$" is often
separated from the value.

So the client gets output with "$" at the right margin and the value
starting on the next line.

Any ideas?




--
PaddyWack

[Graham Mayor]

Are you using a currency switch on the field eg

{Mergefield Fieldname \# "$,0.00"}

The field should then stay together.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



PaddyWack wrote:
I have a project that I maintain for a client.

It uses Word merge documents that have dynamic text based on user
input.

The problem is that when merge fields are formatted as currency and
the dynamic text moves the fields to the right margin, the "$" is
often separated from the value.

So the client gets output with "$" at the right margin and the value
starting on the next line.

Any ideas?

[Doug Robbins - Word MVP]

How is the amount being formatted as currency. If you add the following
formatting switch to the merge field, you will not get a break between the $
and the amount.

\# "$,0.00"

If you want a space between the $ and the amount, you should use a
not-breaking space (Ctrl+Shift+Space), either in the formatting switch, or
if the $ is entered directly into the document, between it and the merge
field.

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

"PaddyWack" wrote in message
...

I have a project that I maintain for a client.

It uses Word merge documents that have dynamic text based on user
input.

The problem is that when merge fields are formatted as currency and the
dynamic text moves the fields to the right margin, the "$" is often
separated from the value.

So the client gets output with "$" at the right margin and the value
starting on the next line.

Any ideas?




--
PaddyWack

[PaddyWack[_2_]]

Was using {MERGEFIELD XYZ \# $#,###}.

Making that {MERGEFIELD XYZ \# $,###} seems to have done the trick, so
long as that handles values = $1,000.

Thanks. Now I can get out of word processor mode and go back to
software development.


Doug Robbins - Word MVP;2738806 Wrote:
How is the amount being formatted as currency. If you add the following

formatting switch to the merge field, you will not get a break between
the $
and the amount.

\# "$,0.00"

If you want a space between the $ and the amount, you should use a
not-breaking space (Ctrl+Shift+Space), either in the formatting switch,
or
if the $ is entered directly into the document, between it and the
merge
field.

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

"PaddyWack" wrote in message
...-

I have a project that I maintain for a client.

It uses Word merge documents that have dynamic text based on user
input.

The problem is that when merge fields are formatted as currency and
the
dynamic text moves the fields to the right margin, the "$" is often
separated from the value.

So the client gets output with "$" at the right margin and the value
starting on the next line.

Any ideas?




--
PaddyWack -




--
PaddyWack

[Graham Mayor]

If you only want whole numbers, the correct switch would be

{MERGEFIELD XYZ \# "$,0" }

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



PaddyWack wrote:
Was using {MERGEFIELD XYZ \# $#,###}.

Making that {MERGEFIELD XYZ \# $,###} seems to have done the trick, so
long as that handles values = $1,000.

Thanks. Now I can get out of word processor mode and go back to
software development.


Doug Robbins - Word MVP;2738806 Wrote:
How is the amount being formatted as currency. If you add the
following

formatting switch to the merge field, you will not get a break
between the $
and the amount.

\# "$,0.00"

If you want a space between the $ and the amount, you should use a
not-breaking space (Ctrl+Shift+Space), either in the formatting
switch, or
if the $ is entered directly into the document, between it and the
merge
field.

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

"PaddyWack" wrote in message
...-

I have a project that I maintain for a client.

It uses Word merge documents that have dynamic text based on user
input.

The problem is that when merge fields are formatted as currency and
the
dynamic text moves the fields to the right margin, the "$" is often
separated from the value.

So the client gets output with "$" at the right margin and the value
starting on the next line.

Any ideas?




--
PaddyWack -