I have tried a lot of different solutions I found on the web (event procedures, macros etc.) to this problem and am obviously missing something.Basically, in this DB, there is a form called Order ...

Step-By-Step: Calculate totals in Access on the fly Your email has been sent Instead of wasting disk space with stored values, you should use calculated fields whenever possible in a database ...

On the Field properties pane, enter the new field size in the Field Size area on the General tab.You can enter a value from 1 to 255, which specifies the maximum number of characters each value ...