Our programmer set up this form many years ago and I would like to find out where the code is (2 Viewers)

[access2010]

If by "brackets" you actually mean "parentheses", use Format property. Review https://support.microsoft.com/en-us...cy-field-e48f2312-67f0-4921-aca0-15d36b7f9c3b

#,###.##%;(#,###.##%);0,000.00

or if you really want brackets

#,###.##%;[#,###.##%];0,000.00

BTW, "Percentage % Stop to Current Price" is displaying as Currency, not Percent. If Currency is correct, why call it a Percentage?

Thank you, June 7, for your link and explanation about percentages.
And pointing out to me the misuse of the word “percent” and showing us how to use a negative number with brackets.
Frida

 

[access2010]

see the Format Property in Design view.

I / we appreciate your assistance, Arnelgp, and for kindly updating our database..
Frida