FarPoint Spread 3.0 entry problem

[PeteG]

Hi,
I have been asked to look into a problem with a VB6 project using the FarPoint Spread 3.0 control (spr32x30.ocx). This is a vbp that I did not create but now need to support...

Whenever a user is keying data into the control, if they complete a full row of data (there are only 3 columns) then the cell-pointer automatically drops to the next row, ie a new line, and the previous row cannot be edited.

That's fine as it stands except that, if the user has started (but not finished) entering the final column of data and then gets interrupted for some reason, if some other application takes the focus on his PC (like if he gets e-mail notification dialogue box), when he goes back to the vb app, it has automatically finished the row (leaving the final column with it's half-complete entry) and gone on to the next one.

In other words, if the vb app window becomes inactive when the user has entered something into all columns, the row is assumed to be complete and a new row is started.

Any help would be greatly appreciated - I can't find any event/property that is causing this but I do not have much experience of this particular control.

Cheers
Pete

 

[PeteG]

I've found out what's causing this. There is a change event. In the change event, the code checks whether all three columns have text in them. If they do then it makes that row un-editable and creates a new row for input.

The problem I have then is that the Change event runs whenever another application is used on the users PC. If they ALT + TAB for instance to some other app, the event runs.

How can I stop the change event running in this situation? The user says that this never used to happen (the app used to be in VB4 and this behaviour has occurred since it was upgraded to VB6...)