Deleting A Record In Datasheet View

In this post, we are going to show you how to delete a record in datasheet view.

Open up a form in MS Access in datasheet view.

 

  • Select the record you wish to delete by clicking in the circled part below.
  • Click in the delete dropdown box in the Records group of the Ribbon.
  • Select Delete Record. Or…
  • Right-click on the record you wish to delete.
  • Select Delete Record.
 Delete A Record In A Datasheet 1  Delete A Record In A Datasheet 2

You will see the dialog box below. This is a warning generated by Access that fires whenever you try and delete an item from the database.

Delete A Record In A Datasheet 3

Click Yes and the record will be gone.

Easy as that!

Not to state the obvious, but when you delete a record in datasheet view, the deletion is, of course, permanent. So, be careful!

Related Posts

Adding A Record In Datasheet View
Formatting A Datasheet
Hyperlinking To A Form
Sorting and Filtering A Record In Datasheet View

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!

Leave a Reply

Your email address will not be published. Required fields are marked *