>Nick,
>
>What happens if you put the line I sent in the interactivechange after your existing code?
>
>Greg
>
>>>Nick,
>>>
>>>Yes...try this line in the keypress event of the textbox in column4.
>>>I left the +1 off of activerow in my first response. This of course will fire no matter what key is pressed. I don't know if that's a problem or not.
>>>
>>>thisform.grid1.activatecell(thisform.grid1.activerow+1,1)
>>>
>>>Greg
>>>
>>>>
>>>>
>>>>Thanks for answering. Would I try this code in my last column (column4)?
>>>>
>>>>thanks
>>>>nick patel
>>
>>
>>It works like a charm Greg. My only problem is that I have code for InteractiveChange as follows that need to be fire first or atleast user needs to enter before move to column1.
>>
>>WITH thisform
>>local shiftchar
>>shiftchar = substr(.pf1.p2.Gridpinfo.Column4.Text1.value, 1, 1)
>>if upper(shiftchar) = "A"
>> .pf1.p2.Gridpinfo.Column4.Text1.value = "A.M."
>>endif
>>if upper(shiftchar) = "P"
>> .pf1.p2.Gridpinfo.Column4.Text1.value = "P.M."
>>ENDIF
>>endwith
>>
>>
>>Is there a way that my interactivechange can be run by user before changing to column1?
>>
>>Thanks
>>Nick Patel
It works great, the only thing is if my user doesn't change anything in column4, it skips the interactivechange method and therefore never executes your code.
thanks
Nick Patel