Hiliting the record selector from code

[rockman]

Not sure if this is a "duh" question, but I can't find an answer in the archives:

How can you hilite the record selector from code (as if the user clicked on the record selector himself/herself)?

Thanks for any help,
Jeff

 

[llkhoutx]

I'm not sure what you mean by "record selector." Do you mean the button like selector to the very left of a record in a form or table view? If so, I don't think that it can be colored.

I hi-lite an entire row of form's datasheet view on the Oncurrent event. However, this method is not obvious. If you want more info, let me know.

 

[rockman]

Thanks for the reply llkhoutx,

Yes, I am referring to the record selector column at the very left of a form (if Form.RecordSelector = True). I'm not looking to color it, I'm looking to duplicate what it looks like when a user clicks it (on my computer that means turn it black and invert the little black triangle).

I'm familiar with the conditional formatting trick to "color" the active record, but that's not really what I'm trying to accomplish here.

Jeff

 

[Oldsoftboss]

You have sort of answered your own question.

I tried it with a cmdButton and put:

DoCmd.RunCommand acCmdSelectRecord

in the event. Thus selecting the record and changing the bar on the left.

HTH

Dave

 

[rockman]

Right on OldSoftBoss!

That's exactly what I was looking for.

I think my problem was... I never use "Select Record" or "Select All Records" from the menu bar so I didn't even know that that RunCommand existed.

Thanks Much!
Jeff

 

[Oldsoftboss]

An interesting excercise is to type

DoCmd.RunCommand

and then hit the space bar. Scroll through the list that pops up. There are some things in there that will raise the eyebrows.

Dave