How to highlights the current record on listbox (1 Viewer)

[Falcon88]

Hii all dears

I have a form that displays single records of a data.
On that form there a list box to show the dates of current patient visits .
My question: how to highlight the date (on the listbox) of the current visit of that patient ?

 

[theDBguy]

Do you mean like "select" that item on the ListBox?

 

[The_Doc_Man]

Look through this post.

How can I show a MS-Access listbox row highlighted?

How can I show a MS-Access listbox row highlighted? I'm using MS-Access 2007. I want the first row of a multiple-column listbox to be showed highlighted through VBA. I tried Me.LstSample.Selected(0...

stackoverflow.com

Not sure if this will do what you want, but the discussion in the linked thread sounds about right.

 

[Falcon88]

I meant:
How do I make the current record on the listbox highlighted in a different color than the rest of the displayed items?

 

[MajP]

A standard Access listbox cannot do color formatting. You can use a listview, but these are hard to work with ActiveX controls. The easier is to fake a listbox with a subform.

alternating row colors in ListBox

Hi All. Is it possible to create alternate row colors in a form ListBox control in VBA Access? If yes. Can someone show how it to do? Is it possible to change font in header ListBox? Thanks

www.access-programmers.co.uk

 

[isladogs]

Sorry. I've only just seen this thread
The selected item in a listbox is automatically highlighted. No code or action needed! For examnple

However it higlights all field in that listbox record
Am I missing something in the question asked?

 

[cheekybuddha]

However it higlights all field in that listbox record
Am I missing something in the question asked?

What does it look like when the focus is on another control?

 

[isladogs]

What does it look like when the focus is on another control?

Providing the listbox row is clicked, it looks exactly the same. The record is still selected.

This particular listbox also works for a mouse move.
Of course, using a mouseover event is transitory. The 'selection' is lost when the mouse is moved away