formatting help

  • Thread starter Thread starter JohnE
  • Start date Start date
J

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.
 
Try this --
Forms!xSOItemCategorySummary.txtFixedBilling = "$" & fixed_billing & "
(+$" + fixed_billing_pos + " / -$" & Abs([fixed_billing_neg]) & ")"
 
Thanks for the reply. Recvd a type mismatch error. The whole line is a text
string. Not being used for anything except display amts.



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

--
Build a little, test a little.


JohnE said:
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.
Click to expand...
Click to expand...
 
Got it. Had to do a minor tweak.
Thanks.

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

--
Build a little, test a little.


JohnE said:
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.
Click to expand...
Click to expand...
 
Back
Top