That should be the case if you also check:
   Open Databases using record-level locking
under:
   Tools | Options | Advanced

However, if another user who is not using record-level locking opens the
database first, you are back to page-level locking, so you are back to page
locking again.

Pete, I probably should also mention that I've had some code fail when
record-level locking is turned on. The code was for merging a duplicate
client into another, along with all their related records (so several tables
affected) inside a transaction. Once record-level locking as turned off, the
code ran fine.