Insert a row into a data sheet

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I would like to insert a row into an existing datasheet..
not at the end, or the beginning. I have follwed the
instructions in the help menu; however, it did not work. I
right clicked on the row header itself, and the closest
option was to click on the -new record- icon, but that's
not what I need to do.
 
Brian,

This cannot be done. To quote Access MVP, an Access table is "an unordered
'bag' of data". If you want to control the position in which a record is
displayed, then you will need to set indexes or create a query in which the
data is sorted by one or more fields.
 
Providing correct attribution for that quote: it is from Access MVP John
Vinson.
 
Back
Top