Hi

How do I include a second switch in a field that already contains a switch?

I want to create a field switch which controls the number of digits on the
right hand side of the decimal point and which also suppresses zero dollar
values

I know the following switch works to control the number of digits on the
right hand side of the decimal point...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)"}

....but when I add a second switch (i.e., \#"$0.00;;") to the above field to
give the following field...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)" \#"$0.00;;"}

....I get the following error:

"Error! Too many picture switches defined."

Any suggestions would be greatly appreciated.

Thanks
Anthony

If you don't want the number zero to be displayed, use # instead of 0
before the decimal point (in the field code):

{ MERGEFIELD "item_No1" \# "$#.00;($#.00)" }

--
Stefan Blom
Microsoft Word MVP


"Anthony Dowd" wrote in message
...
Hi

How do I include a second switch in a field that already contains a
switch?

I want to create a field switch which controls the number of digits
on the
right hand side of the decimal point and which also suppresses zero
dollar
values

I know the following switch works to control the number of digits on
the
right hand side of the decimal point...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)"}

...but when I add a second switch (i.e., \#"$0.00;;") to the above
field to
give the following field...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)" \#"$0.00;;"}

...I get the following error:

"Error! Too many picture switches defined."

Any suggestions would be greatly appreciated.

Thanks
Anthony

Hi Stefan

First of all thanks for your response and I apologise for not making myself
clear.

If there is a zero value in the field I want to leave the field completely
blank. Any suggestions?

Thanks
Anthony
"Stefan Blom" wrote in message
...
If you don't want the number zero to be displayed, use # instead of 0
before the decimal point (in the field code):

{ MERGEFIELD "item_No1" \# "$#.00;($#.00)" }

--
Stefan Blom
Microsoft Word MVP


"Anthony Dowd" wrote in message
...
Hi

How do I include a second switch in a field that already contains a
switch?

I want to create a field switch which controls the number of digits
on the
right hand side of the decimal point and which also suppresses zero
dollar
values

I know the following switch works to control the number of digits on
the
right hand side of the decimal point...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)"}

...but when I add a second switch (i.e., \#"$0.00;;") to the above
field to
give the following field...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)" \#"$0.00;;"}

...I get the following error:

"Error! Too many picture switches defined."

Any suggestions would be greatly appreciated.

Thanks
Anthony

Try the following:

{ MERGEFIELD "item_No1" \# "$#.00;($#.00);" }

--
Stefan Blom
Microsoft Word MVP


"Anthony Dowd" wrote in message
...
Hi Stefan

First of all thanks for your response and I apologise for not making
myself
clear.

If there is a zero value in the field I want to leave the field
completely
blank. Any suggestions?

Thanks
Anthony
"Stefan Blom" wrote in message
...
If you don't want the number zero to be displayed, use # instead
of 0
before the decimal point (in the field code):

{ MERGEFIELD "item_No1" \# "$#.00;($#.00)" }

--
Stefan Blom
Microsoft Word MVP


"Anthony Dowd" wrote in message
...
Hi

How do I include a second switch in a field that already contains
a
switch?

I want to create a field switch which controls the number of
digits
on the
right hand side of the decimal point and which also suppresses
zero
dollar
values

I know the following switch works to control the number of digits
on
the
right hand side of the decimal point...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)"}

...but when I add a second switch (i.e., \#"$0.00;;") to the
above
field to
give the following field...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)" \#"$0.00;;"}

...I get the following error:

"Error! Too many picture switches defined."

Any suggestions would be greatly appreciated.

Thanks
Anthony

Works beautifully, Stefan.

Thanks heaps.

Anthony



"Stefan Blom" wrote in message
...
Try the following:

{ MERGEFIELD "item_No1" \# "$#.00;($#.00);" }

--
Stefan Blom
Microsoft Word MVP


"Anthony Dowd" wrote in message
...
Hi Stefan

First of all thanks for your response and I apologise for not making
myself
clear.

If there is a zero value in the field I want to leave the field
completely
blank. Any suggestions?

Thanks
Anthony
"Stefan Blom" wrote in message
...
If you don't want the number zero to be displayed, use # instead
of 0
before the decimal point (in the field code):

{ MERGEFIELD "item_No1" \# "$#.00;($#.00)" }

--
Stefan Blom
Microsoft Word MVP


"Anthony Dowd" wrote in message
...
Hi

How do I include a second switch in a field that already contains
a
switch?

I want to create a field switch which controls the number of
digits
on the
right hand side of the decimal point and which also suppresses
zero
dollar
values

I know the following switch works to control the number of digits
on
the
right hand side of the decimal point...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)"}

...but when I add a second switch (i.e., \#"$0.00;;") to the
above
field to
give the following field...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)" \#"$0.00;;"}

...I get the following error:

"Error! Too many picture switches defined."

Any suggestions would be greatly appreciated.

Thanks
Anthony

I'm glad I could help.

--
Stefan Blom
Microsoft Word MVP


"Anthony Dowd" wrote in message
...
Works beautifully, Stefan.

Thanks heaps.

Anthony



"Stefan Blom" wrote in message
...
Try the following:

{ MERGEFIELD "item_No1" \# "$#.00;($#.00);" }

--
Stefan Blom
Microsoft Word MVP


"Anthony Dowd" wrote in message
...
Hi Stefan

First of all thanks for your response and I apologise for not
making
myself
clear.

If there is a zero value in the field I want to leave the field
completely
blank. Any suggestions?

Thanks
Anthony
"Stefan Blom" wrote in message
...
If you don't want the number zero to be displayed, use #
instead
of 0
before the decimal point (in the field code):

{ MERGEFIELD "item_No1" \# "$#.00;($#.00)" }

--
Stefan Blom
Microsoft Word MVP


"Anthony Dowd" wrote in message
...
Hi

How do I include a second switch in a field that already
contains
a
switch?

I want to create a field switch which controls the number of
digits
on the
right hand side of the decimal point and which also suppresses
zero
dollar
values

I know the following switch works to control the number of
digits
on
the
right hand side of the decimal point...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)"}

...but when I add a second switch (i.e., \#"$0.00;;") to the
above
field to
give the following field...

{MERGEFIELD "item_No1"\#"$0.00;($0.00)" \#"$0.00;;"}

...I get the following error:

"Error! Too many picture switches defined."

Any suggestions would be greatly appreciated.

Thanks
Anthony