I have a form that is a datasheet view form. There are two fields on the form. One is Category (cboCategory) and the other one is NetAmount (txtNetAmount). If Category = "Volume" then I want txtNetAmount to display as Currency But Just For That Record.
Right now if I select "Category" all of the Net Amounts display as currency in all of the records. They need to display as Single, Standard, 2 decimals like the field is formatted in the table.
What am I doing wrong?