formatting help

[JohnE]

I am using the following and need to put the end result formatted as
currency. It is a string inside of a textbox. The fixed_billing_pos is fine
the way it is. The fixed_billing_neg is a negative dollar amt and the way it
shows in the txtbox is $-1234. Is there a way to format the neg sign before
the $ sign? Also, need to add .00 after each.

Forms!xSOItemCategorySummary.txtFixedBilling = "$" & fixed_billing & "
(+$" + fixed_billing_pos + " / $" & fixed_billing_neg & ")"

Thanks.

 

[KARL DEWEY]

Try this --
Forms!xSOItemCategorySummary.txtFixedBilling = "$" & fixed_billing & "
(+$" + fixed_billing_pos + " / -$" & Abs([fixed_billing_neg]) & ")"

 

[JohnE]

Thanks for the reply. Recvd a type mismatch error. The whole line is a text
string. Not being used for anything except display amts.

Try this --
Forms!xSOItemCategorySummary.txtFixedBilling = "$" & fixed_billing & "
(+$" + fixed_billing_pos + " / -$" & Abs([fixed_billing_neg]) & ")"

--
Build a little, test a little.

I am using the following and need to put the end result formatted as
currency. It is a string inside of a textbox. The fixed_billing_pos is fine
the way it is. The fixed_billing_neg is a negative dollar amt and the way it
shows in the txtbox is $-1234. Is there a way to format the neg sign before
the $ sign? Also, need to add .00 after each.

Forms!xSOItemCategorySummary.txtFixedBilling = "$" & fixed_billing & "
(+$" + fixed_billing_pos + " / $" & fixed_billing_neg & ")"

Thanks.

 

[JohnE]

Got it. Had to do a minor tweak.
Thanks.

Try this --
Forms!xSOItemCategorySummary.txtFixedBilling = "$" & fixed_billing & "
(+$" + fixed_billing_pos + " / -$" & Abs([fixed_billing_neg]) & ")"

--
Build a little, test a little.

I am using the following and need to put the end result formatted as
currency. It is a string inside of a textbox. The fixed_billing_pos is fine
the way it is. The fixed_billing_neg is a negative dollar amt and the way it
shows in the txtbox is $-1234. Is there a way to format the neg sign before
the $ sign? Also, need to add .00 after each.

Forms!xSOItemCategorySummary.txtFixedBilling = "$" & fixed_billing & "
(+$" + fixed_billing_pos + " / $" & fixed_billing_neg & ")"

Thanks.