I have a feeling this maybe can't be done but figured I'd give it a shot anywa. I have a table which has an "amount" column. That column can either hold a percentage value, or a dollar amount. I'd like to be able to approrpriately format the number in my forms depending on the type.
So basically, my question is: Can a single textbox (on a CONTINUOUS form) be conditionally formatted to either percent or currency, based on another column in the recordset?
Thanks!
So basically, my question is: Can a single textbox (on a CONTINUOUS form) be conditionally formatted to either percent or currency, based on another column in the recordset?
Thanks!