Highlight specific record in a continuous form

[Zeroanarchy]

Hi I am refering to thread702-693007, does anyone know how one would make this work in Access 2002.

Instead of highlighting the row with a solid line it hightlights it with

=IIf([SelTop]=[ctlCurrentLine],"ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ",Null)

Cheers

ZeroAnarchy
Experience is a wonderful thing. It enables you to recognize a mistake
when you make it again.

 

[hermanlaksko]

Via format try "Conditional formating" this should help you along the way.


Herman
Say no to macros

 

[TheAceMan1]

Zeroanarchy . . .

I agree with [blue]hermanlaksko[/blue] in relation to [blue]Conditional Formatting[/blue], but you've simply related a thread and havn't stated what you intend to do.

Do you want to:
[ol][li]Hilite the currently selected record?[/li]
[li]Hilite records per some criteria?[/li]
[li]Hilite records per some scheme?[/li][/ol]
What? . . .

. . . and what version access your using?

See Ya! . . . . . .

 

[Zeroanarchy]

Hi,

I was trying to highlight a selected row on a button press. The old method worked fine in Access 97 but when I converted to 2002 I came across the above problem. I ended up using the Conditional format but I must say it is a bit short in it's ability. I happened to have 5 values and Conditional format only allows for 4.

My work around was to use highligh visible = False for empty values. I had to scrap the button press because it was no longer valid. Instead I placed a small field and coloured it depending on the value in the field.

Cheers


ZeroAnarchy
Experience is a wonderful thing. It enables you to recognize a mistake
when you make it again.

 

[TheAceMan1]

Zeroanarchy . . .

Perhaps this will help Adding Additional Conditional Formatting in Access with VBA

See Ya! . . . . . .