Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In Access 2010, if I select a subset of the cells in a column, the Delete key does nothing, and there is no Delete item on the context menu.

Is there some trick to clearing the contents of a selection of cells in Access 2010, or is this a glaring oversight on the part of Microsoft?

share|improve this question
    
Access is not a spreadsheet and expecting it to behave like one will always lead you into problems. –  David W. Fenton Sep 29 '10 at 0:15

2 Answers 2

up vote 2 down vote accepted

If you were using Excel, this solution would work:

Try pressing CTRL and the Minus key simultaneously, or Right Click and choose Delete.

You'll have to specify whether the remaining cells get shifted left or up when the selected cells are deleted.

The way you phrased your question, I thought you were using Excel, not Access.

I think the issue is that Access is fundamentally different from Excel. Even though an Access table looks like a spreadsheet, is not a spreadsheet of cells... it is a table of rows and columns. You can delete entire rows or entire columns (fields), but you can't delete "cells" in the middle of a column or row like you do in Excel. In many cases, you can erase the data in a given set of row / column intersections, but you'd have to do them one row at a time. (BTW, deleting "cell" data in Access really means you are setting the value to NULL, which in database terminology means there is no value stored.)

I hope this helps!

share|improve this answer
    
Ctrl+- does nothing and, as I said, there is no Delete item on the context menu. –  raven Sep 28 '10 at 20:36
    
UPDATE query The proper way to delete the value stored in a column for a given set of rows is to use an UPDATE query, which you can do using the Query Designer. I am a SQL Server DBA, and I write SQL code instead of using designers. The SQL statement would be something like UPDATE table SET fieldname = NULL WHERE KeyField IN (comma separated list of IDs) –  stewartwb Sep 28 '10 at 20:41
    
My question was misleading. Selecting a column and hitting delete removes the column, it doesn't clear the contents (I edited my question). I was thinking in terms of spreadsheet, not database. I was looking for a way to do it through the UI, SQL never crossed my mind, but that will do it. Thanks. –  raven Sep 28 '10 at 22:02

This will work: Copy the same number of empty cells from a nearby field. Select all the cells you want to clear and paste the cleared cells.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.