igrid's method of clearing the contents of a cell when focus is on the cell is by pressing the spacebar. But when one press the del key or the backspace key, nothing happens. This causes inconveniences because the standard windows operation for clearing should be the del or backspace keys but is not implemented in igrid

H-m, you are right. Even when a standard grid (such as MS Excel) is not in edit mode, DEL and BACKSPACE clear the cell contents. We wonder why nobody from our customers has reported this issue during the past 10 years of iGrid's existence.

We'll correct the iGrid functionality in the next forthcoming update correspondingly.

Thanks for the positive feedback. Prompt reply as usual. Keep up the good work

Hi Igor

I'm happy you implemented this Excel-like behaviour to clear cell content :-)

One thing I miss is that no event seems to be triggered (especialle AfterCommitEdit and BeforeCommitEdit) if a cell is cleared using BACKSPACE or DELETE keys.
As a work-around I had to use KeyDown and KeyUp events just to react on cell changes induced by 'Backspace' or 'Delete' keys.

Or, is there another, means 'global', way to react on every kind of cell value changes?

Regards,
Marc

This should definitely work in the latest release (5.0.74).

If you press the DELETE key, the cell contents are cleared, and AfterCommitEdit is raised for the cell(s).

As for BACKSPACE, iGrid is put into edit mode when you press it, and AfterCommitEdit will be raised in the case when the user commits the editing.

If this does not work for you, send us a sample to demonstrate the problem, please.

Hi Igor,
I have recently purchased the ActiveX version of iGrid (Version 5.00, build 0090).

I am using iGrid in the MS Access 2003 environment as a control on a userform in Multiselect mode.

The delete key does not seem to have any functionality in the iGrid. That is, when the user presses the delete key it does not clear the content of the selected cell(s) and it does not raise the iGrid KeyDown event. I had expected it would clear the content of the selected cell(s).

Whether or not the iGrid is in edit mode or not makes not difference. It still doesn't clear the cell contents.

I have changed the the KeyPreview property of the userform and set it to both 'Yes' and 'No' at different times without any success.

I note in an earlier post that this functionality should be present from version 5.0.74 but it does not seem to be the case. Is the multiselect property a factor?

It's not a a real big deal as I can capture the KeyDown event of the userform, use SelItems.GetArray and then loop through all selected cells to change the value of each cell to Null. The functionality is just not what I would expect.

Look forward to hearing your thoughts.


DaveP

I have just tried that with the latest public iGrid (5.0.90) but in MS Access 2010 - all works as expected.

If I turn the multiselection mode on, select several cells with data using CTRL+click, and then hit DEL - the contents of the selected cells are cleared.

Can you try this in MS Access 2010 or 2013?

Can you also send me a sample that does not work in your Access 2003 so I can check it in my dev environment?

Hi Igor,
I can't try it in Access 2010 or 2013 as I don't have either version installed.

However I will email you a copy of the Access 2003 file soon.

Thanks

DaveP

Hi Igor,

I can confirm I have the same problem (although I cannot reproduce it).
My environment is:
iGrid 5.0.90, MS Access 2013.
After loading data set from SQL Server using ADODB recordset object, I cannot use Del or Backspace keys to modify the numbers in cells. The Editable property is set to True.
I created a new form, placed the iGrid control and copied the code behind. I can double click and delete the value inside a cell. Seems like something has locked the original grid, and I have no idea what.

Regards,
MinkaT

I've got the DaveP sample, but it works ok on my test pc (an HP ultrabook with Windows 8.1 Pro and MS Access 2010).

I think the problem is somewhere in the MS Access settings. I tried to search the Internet, and here is one interesting discussion thread I found:

Probelm with Delete Key in ActiveX in Access Form 

As you can see, the author tells us that DELETE and BACKSPACE may not work if we switch the bound mode of an MS Access form.

At the moment I have no ideas what it can be - just one comment from my experience.

http://office.microsoft....tabases-HA010341491.aspx ). If it is set not to "Don't Move", we may never see ENTER in our ActiveX grid or any other control on an MS Access form.

I think guys you also need to experiment with your MS Access settings trying to find the missing bit.

Hi Igor,

Thank you very much for your reply. I worked out what caused the problem (using the first link you provided).
In my case I have created two data bound forms (i.e. their Record Source property is set to a table or query at design time).

My original form uses linked table. After Job number is entered in a text box, the data is filtered and only couple of records are displayed in the Detail section (the form is set to Continuous form). Data Entry, Editions etc. are set to True (and because I am using a table, I can see the "New" record). The iGrid is placed in the form Footer and shows Employee hours by Date. This is where the Hours could not be deleted using Del or Backspace keys.

In the second form I created, the Record Source of the form is a Crosstab query (producing non-updatable recordset, although Allow Editions and Data Entry are True). The rest is exactly the same. In this case the iGrid allows me to delete the Hours displayed in each cell.

So, if the form has updatable recordset (and can accept New records), the iGrid control cannot accept Del and Backspace keys.
The solution is to use recordset and programmatically control navigation, data entry and updates in the form. Or, use a subform, which could be bound. I already tested it.

Hope that will help others.

Regards,
MinkaT