relativeRow = IF the active recNo have RelativeRow<>0 THEN Grid change the relativeRow and BeforeRow... don't fire ELSE change the RECNO to the EVL(relativeRow,1) and BeforeRowCol.. is firedwhen a grid is not the thisform.ActiveControl,
relativeRow = IF the active recNo have RelativeRow<>0 THEN Grid change the relativeRow and BeforeRow... don't fire ELSE change the FirstRow.RECNO so that the active record asset RelativeRow centered in the gridWith grid active, grid.setFocus don't fix the ELSE change recno issue.
>*clmAddDate.header1.click >LOCAL lnRec, lsOrder, lnColor >STORE "" to lsOrder, lnColor >lnRec = RECNO() > >* tag is the field name >lsOrder=ThisForm.mGetTag(This.Tag) >lnColor = This.ForeColor >* get current text color >IF lnColor = RGB(128,0,128) && purple color > lnColor = RGB(0,0,0) && black color > SET ORDER TO >ELSE > WITH This.Parent.Parent > IF TAGNO(lsOrder)>0 && This index already exists (assume simple indexes tagname=fieldname) > SET ORDER TO (lsOrder) > ENDIF && TAGNO( > lnColor = RGB(128,0,128) && purple color > .clmUserId.header1.ForeColor = RGB(0,0,0) > .clmEmpId.header1.ForeColor = RGB(0,0,0) > .clmFullName.header1.ForeColor = RGB(0,0,0) > .clmOrg.header1.ForeColor = RGB(0,0,0) > .clmClasses.header1.ForeColor = RGB(0,0,0) > .clmCity.header1.ForeColor = RGB(0,0,0) > .clmBldg.header1.ForeColor = RGB(0,0,0) > .clmDates.header1.ForeColor = RGB(0,0,0) > ENDWITH >ENDIF && lnColor = RGB( >This.ForeColor = lnColor >This.Parent.Parent.Refresh() > >GOTO lnRec >This.Parent.Parent.clmAddDate.SetFocus >>