Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Two switches in the one field
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DDE field doesn't update when printing after applying word 2000 sp3 | Mailmerge | |||
Enter data in 1 text form field & have multiple locations fill | Microsoft Word Help | |||
filename field switches - anything besides /p? | Microsoft Word Help | |||
Switches for Fields | Microsoft Word Help | |||
Text Form Field Ref in Footer Won't Update on Screen | Microsoft Word Help |