>>vvgrid.COLUMNS[14].CONTROLSOURCE= "IIF(Month(lv_compete.competedate=1.and.Day(lv_compete.competedate)=1,AllTrim(Str(Year(lv_compete.competedate))),AllTrim(Str(Month(lv_compete.competedate))) + ' - ' + Right((AllTrim(Str(Year(lv_compete.competedate)))),2))"

>Try putting an "=" in front of the IIF.


As it turns out the syntax was wrong...should of been this:

IIF((Month(lv_compete.competedate) = 1 and Day(lv_compete.competedate)=1), (AllTrim(Str(Year(lv_compete.competedate)))), (AllTrim(Str(Month(lv_compete.competedate))) + ' - ' + Right((AllTrim(Str(Year(lv_compete.competedate)))),2)))

I had a little problem with the ()'s.
The = sign wasn't necessary, but I understand why you suggested it.