ms access datasheet select a specif record

1. I need to jump N reocrds down/up in an ms access datasheet.

2. I'd like to mark the current record in my datasheet by highlighting the whole row, and not just a single field in the record (similar to what's happen when the user presses the record selector)

any ideas?

I got 1. solved (recordset.move)

anyone about highlighting the whole row?

anyone?

someone?

Hello,

2. I'd like to mark the current record in my datasheet by highlighting the whole row, and not just a single field in the record (similar to what's happen when the user presses the record selector)

any ideas?[/QUOTE]


I would also really like to know how to mark the current record by highlighting the whole row! Anyone?

you select the row using

rows(row:row).select
e.g
rows("5:5").select

Selection.Interior.Color = RGB(255, 255, 0)
or
Selection.Interior.Color = vbyellow
or
Selection.Interior.Colorindex = 24

you will need to know the red green blue mix the vbnamed color range or the color index values for your choices