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
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