PRB: Error Occurs When Using DynamicCurrentControl PropertyID: Q135522 The information in this article applies to:
SYMPTOMSWhen setting the DynamicCurrentControl property of a column contained within a grid, you may get the error message "Expression is invalid. Use a valid expression for DynamicCurrentControl property."
CAUSEThis error message may occur if you used the Expression Builder to create your DynamicCurrentControl property expression. The DynamicCurrentControl property sets the active control of a column based on a certain condition. This is typically accomplished with an in-line if (IIF) statement. When you add an IIF statement to the DynamicCurrentControl property, Visual FoxPro assumes that an equal sign (=) resides at the beginning of the statement. If you have the Expression Builder creates your IIF statement, it adds an equal sign as the first character and thus cause the error message.
RESOLUTIONRemove the equal sign inserted by the Expression Builder, or do not use the expression builder to create your IIF statements for the DynamicCurrentControl property.
STATUSThis behavior is by design.
MORE INFORMATION
Steps to Reproduce Behavior1. Open or switch to Microsoft Visual FoxPro. 2. Open a new form and add a grid to it. 3. Add the Employee.dbf table, located in the \Samples\Data subdirectory of 4. In the form's Property window, set the grid's ColumnCount property to 1,
5. Add a text frame to the Column (this will be Text2 as there will be a
6. In the form's Property window, set the Value property of Text2 to Test.
7. Set the ControlSource property of Text1 to Employee.emp_id. 8. Use the Expression Builder to create the following statement for the 9. Close the Expression Builder. Note that it adds an equal sign (=) to the
10. Save and run the Form. Note that the error "Expression is invalid. Use
11. Remove the equal sign added by the Expression Builder, and run the
Additional reference words: 3.00 VFoxWin
KBCategory: kbprg kbprb
KBSubcategory: FxprgGeneral
|
Last Reviewed: August 24, 1995 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |