How To Create a Calculated Column in a GridLast reviewed: October 18, 1996Article ID: Q138981 |
The information in this article applies to:
SUMMARYYou can create a calculated column in a grid by entering the calculation in the ControlSource property for the column.
MORE INFORMATION
Step-by-Step ExampleThe following steps create a form containing a simple grid. The third column of the grid is the product of the values in the first two columns.
The grid will not automatically update a field in the table because the ControlSource is not bound to a specific field. If you need to store the calculation in a field, add the following code to the AfterRowColChange event, or to the record validation in the Database Designer:
REPLACE fieldname WITH unit_price * quantity |
Additional reference words: 5.00 3.00 VfoxWin
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |