Matrix Cell cancel change

[Former Member]

Hi,

Who knows how to cancel a validate on a Matrix cell

I'm tried with bubbleevent = false but the column is still going to the other one.

For instence, I'm on the Unit Price in the detail of a Sales Order. I'm able to get the value of the cell beeing modified but if the user doesn't enter the right one, I would like to STAY on that cell not going anywhere until the user enter the right value.

[Former Member]

my bubbleevent = false was just not at the right place.

[Former Member]

Well it seems that even of I'm getting out of ItemEvent

with a bubbleevent = false

it doesn't mean anything for the Matrix which still go on to the other column.

I'm looking for a way to keep the user in the same cell until his value is correct.

I can pop a message to the user for an incorrect value and set the BubbleEvent = true but after the message is confirmed, it changes to the next cell anyway.

I've tried with SendKeys to go back no luck. I tried with with Cell Click, no luck too.

Any idea ?