Combining a two differently formated fields into one text box

[Guest_imported]

Hello,
I have a total textbox that contains a field 'fldTotal' formatted to ‘Standard’ with ‘2’ decimal places. This textbox is meant to represent currency without the ‘$’ symbol. The reason is because the particular form has to be able to handle international currencies. I have another field called Symbol which im trying to incorporate into the total textbox: eg, =[fldSymbol]& “ “ &[fldTotal]
Doing this works, however the format of the fldTotal changes. Resulting in the total missing commas and a varying amount of decimal places.
If anyone knows how a can combine these two fields while keeping their correct format, it would be greatly appreciated Thanks.

 

[mashelford]

Hi

try using the format function in your coding;

=[fldSymbol]& “ “ &format([fldTotal],"#,##0.00;-#,##0.00&quot

Martin

 

[Guest_imported]

Thanks alot Martin!
That works perfectly
Cheers!