Hi Guys
I have 2 tables, one, TblPaper, has Paper Size, Paper Quality, Paper Type and Price. The other, TblSale, has details such as date, staff name, unit price and total price and has a n-1 relationship with TblPaper.
I've created a form based on TblPaper and have a combo box on the form that has the all of the paper details in it. When the user 'clicks' on the combo box they can choose the type, size and quality of the paper and the price is also displayed. At the moment the price is only displayed as to 2 decimal places. I need it to display 4 decimal places. I've formatted the combo cox as General and set the Decimal Places to 4, but it still doesn't work.
Any ideas?
Dave
I have 2 tables, one, TblPaper, has Paper Size, Paper Quality, Paper Type and Price. The other, TblSale, has details such as date, staff name, unit price and total price and has a n-1 relationship with TblPaper.
I've created a form based on TblPaper and have a combo box on the form that has the all of the paper details in it. When the user 'clicks' on the combo box they can choose the type, size and quality of the paper and the price is also displayed. At the moment the price is only displayed as to 2 decimal places. I need it to display 4 decimal places. I've formatted the combo cox as General and set the Decimal Places to 4, but it still doesn't work.
Any ideas?
Dave