I have a field on my table that can be either a percent or dollar add on ([price_margin] - decimal) with another field that tracks which type it is ([margin_is_dollar_add] - true/false). I'd like to be able to display that field on a continuous form with the proper number formatting. As far as I can tell, the conditional format box only allows font color, bold/italic/underline and fill color. Are there any options for changing the number format based on a condition?
I'm using MS Access 2016.