How do you delete text data from multiple cells?

[creolejazz]

This is bound to be a stupid question but I can't find the answer. I need to clear the text data from a single field for about 400 consecutive records. So, in my table, I click the first cell that needs to be cleared, scroll down to the last cell that needs to be cleared, then SHIFT+CLICK and now all the cells I need to clear are highlighted. I thought I'd be able to hit DELETE and clear them all but it doesn't work.

 

[odin1701]

Is the data the same?

You could do a find/replace. In the find box, put a * and in the replace box put ""

This will do it for the whole table though, not the selection. Can you do a query that will select only these 400 records? If so, you can also use an update query to replace the data.

 

[creolejazz]

Thanks. The find/replace definitely won't work. I don't want to delete records or fields.

I had never heard of the "update query" so, "thanks". That worked great!