asked on Format as currecy for just the one current record
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?
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?
Microsoft Access
Last Comment
SteveL13
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect explanation.