I have a report that shows tax amounts in various currencies.
I want the tax amount to be formatted with square bracketing and the variable currency symbol shown like:
At the report detail format event I use vba:
Me!sInvoiceTax = "[" & GroupCurrencySymbol & Format(InvoiceTax, #,##.0.00) & "]"
At the group footer format event I tried to use vba:
Me!txtTotalInvoiceTax = "[" & GroupCurrencySymbol & Format(sum([InvoiceTax]), "#,###,##0.00") & "]"
but function sum is not recognised.
Instead I would prefer to have a bound text box in the group footer with control source:
and use the property sheet text box format property:
"[ $"#,##0.00"]" but to change the $ to be my variable GroupCurrencySymbol
but I don't know how to set up the text box format property to do this. How can I achieve the formatting I need, either via the property sheet or vba.