>Hi everyone,
>
>I'm using VFP5. I tried to put in a complex expression that evaluates to a text in one of the columns of my grid but the form designer won't accept it. An error message appears stating that only variable name or field name is allowed for the property. The expression is of the form IIF(,,cexpression>. I tried to put the same expression in the control source of text1 under the specific column and I get the same problem. Is there a way to work around this?
>
>Thanks.
>
>Ed Fabonan

Yes, this can be done.

1) Make sure you put the expression in the column, not in the textbox.

2) Make sure the expression is valid. For instance, you may have an unbalanced parenthesis. Better test with a relatively simple expression first, and then make it more complicated.

HTH, Hilmar.

Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)