How to detect user pasting multiple rows into a datasheet

[EddieN1]

I have a datasheet application that updates additional fields based on the input of one field using VBA code. Due to the design constraints, I use the following technique...



1. After the field is updated, I do a Refresh to save the row
2. Then I retrieve the other values I need using VBA code and save them.
3. Finally, I read the saved row, update the additional fields, and update the row.

This works fine as long as the operator enters the new row manually or even if he/she does a copy & paste of one row. However, if he/she copies and pastes multiple rows, then the Refresh doesn't insert the multiple rows and my step 3 above fails. Is there a way I can detect that multiple rows are being inserted so I can handle the event accordingly?

(Please don't give me another technique to update the records, there is a reason I'm doing it this way.)

Thanks, Eddie

[June7]

Perhaps in BeforeUpdate event set a public/global variable for the record count, check this against the record count in AfterUpdate.

[EddieN1]

Here's the deal. The paste part of the process works just like an operator entering the data one field at a time. Bear in mind that if a control is locked, nothing will be pasted into those controls. On the copy part the contents of only shown controls get copied. If a control isn't on the form or is hidden, its contents won't be copied.

As far as pasting multiple rows, the update events are triggered, so you can trap before update, after update, etc. However, the data won't actually exist in the table until the operator confirms the "Okay to Paste" dialog box at the end.

[June7]

Sorry, I misread your original post and on reread see my suggestion was not relevant. You can detect how many rows are selected with SelHeight property:

intHeight = Me.SelHeight