docvariable fields - force negative numbers to disred OR paren - h
Specifically, what would syntax be:
Now I am passign value as follows:
worddoc.variables(wordField).value = Cstr( Format (Cdbl (tmpItem.text) ,
"#,0.00") )
I suppose I would add another line under this (the Word doc has NOT been
updated yet), that (If value is negative Then)
worddoc.variables(wordField).font.color = wdColorRed
???? I know this syntax is wrong, but here is where I need help!
Thanks.
"Lisa" wrote:
How do you force a negative doc variable field (popualtesd via OLE from
another application) to either appear red in Word OR display as opena nd
close parenthesis? Standard formatting option froces two decimals which is
not aloowed, so am looking fro antoerh way.
Thanks!!
|