>>>>>
>>>>>VFP7 Column object has DynamicAlignment property. can this run in anyway?
>>>>
>>>>Try them. I think both must work, but with DynamicAlignment it is much easier.
>>>
>>>i try DynamicAlignment but not work ? why
>>>
>>>
>>>Thisform.Grid1.Column1.DynamicAlignment = [iif(MyTable.nField = 1, "1", "0")]
>>>
>>
>>Alignment is not a string it is numeric:
>>
>>[iif(MyTable.nField = 1, 1, 0)]
>>
>
>but it is in vfp help
>
>Column.DynamicAlignment[ = cAlign]
>Property Values
>cAlign
>Specifies a character string expression that is re-evaluated at run time and results in one of the following values:
Yes, the property must be sting. That string is evaluated to get the right value of the Alignment.
[iif(MyTable.nField = 1, 1, 0)]
This IS string, see square brackets around IIF(). That makes it string, BUT the the value which is returned after evaluation must be numeric. That is something like this:
lcString = [iif(MyTable.nField = 1, 1, 0)]
thisform.Column.Alignment = EVALUATE(lcString)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.