docvariable fields - force negative numbers to disred OR paren - h

L

Lisa

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

Lisa

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top