Conditional Formatting Rows 'highlighting' (1 Viewer)

Hi all,

I've tried to use conditional formatting as a way to make the selected row easier to see as a form of highlighting, but the closest i can get is having all of the rows be formatted. what I'm trying to achieve is when a row is selected, it formats the background.

How I've gone about this so far is I've made all the fields in the row transparent and then put a text box behind them, then i made a current ID field in the footer which is equal/displays the same value as the primary key autonumber value, and then set a conditional format on the text box with the expression;
"[Primary Key] = [Current ID]"
what i get is all the rows being affected.

Any help on how i could get it to just format one row at a time?

Regards- Hek

It sounds correct except are you telling me the PK is really called [Primary Key]? You Serious?
And if I understand correctly [current ID] is the name of the textbox and on the forms on current event you set me.[current id] = me.[Primary Key]

Stop using spaces. You are killing yourself. Use better names.

Yes you can highlight just one row in a continuous form using the sort of approach you were describing
For example, see this emulated split form .
It will work for any continuous form - not just for split forms