how to highlight cursor selected row?

alex_raju

New member
Local time
Yesterday, 19:06
Joined
Dec 5, 2009
Messages
4
hi,

how to highlight cursor selected current row in Continuous Forms?
 
I do it like this:

Create a public var pbKeyID

in the OnCurrent event of the form put the line:
pbKeyID = me.KeyID

create a function
function GetpbKeyID() as long
GetpbKeyID = pbKeyID
end function

create a TextBox on your form, put it under all the other fields and set it's RowSource to:
IIf([KeyID] = GetpbKeyID(), "X", "")

This will be true only for the selected record

now use ConditionalFormat to format this text box when it's value = X to whatever you wish
 

Users who are viewing this thread

Back
Top Bottom