Microsoft KB Archive/135522

= PRB: Error Occurs When Using DynamicCurrentControl Property =

Article ID: 135522

Article Last Modified on 2/15/2000

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition

-



This article was previously published under Q135522



SYMPTOMS
When 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."



CAUSE
This 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.



RESOLUTION
Remove the equal sign inserted by the Expression Builder, or do not use the expression builder to create your IIF statements for the DynamicCurrentControl property.



STATUS
This behavior is by design.



Steps to Reproduce Behavior
 Open or switch to Microsoft Visual FoxPro. Open a new form and add a grid to it. Add the Employee.dbf table, located in the \Samples\Data subdirectory of Visual FoxPro, to the data environment of the form. In the form's Property window, set the grid's ColumnCount property to 1, and set the Bound property of Column1 to false (.F.). Add a text frame to the Column (this will be Text2 as there will be a text frame called Text1 in the Column by default).</li> In the form's Property window, set the Value property of Text2 to Test.</li> Set the ControlSource property of Text1 to Employee.emp_id.</li>  Use the Expression Builder to create the following statement for the DynamicCurrentControl property of Column1: IIF((LEFT(ALLTRIM(EMPLOYEE.EMP_ID),1) = "1"), "TEXT1", "TEXT2") </li> Close the Expression Builder. Note that it adds an equal sign (=) to the beginning of the statement.</li> Save and run the Form. Note that the error "Expression is invalid. Use a valid expression for DynamicCurrentControl property" appears.</li> Remove the equal sign added by the Expression Builder, and run the form. Note that if now functions as expected.</li></ol>

Additional query words: 3.00 VFoxWin

Keywords: KB135522

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.