UtterAccess Discussion Forums > Select Last Item In A List box

Full Version: Select Last Item In A List box

UtterAccess Discussion Forums > Microsoft® Access > Access Forms

wkalo

Dec 10 2007, 06:22 AM

I Have A List Box Its Filled Automatically By A Query,
is there a way to enforce selecting a specific record,

Larry Larsen

Dec 10 2007, 06:25 AM

Hi
Try:

CODE

Me.YourLstboxName = Me.YourLstboxName.Column(0, Me.YourLstboxName.ListCount - 1)

wkalo

Dec 10 2007, 06:30 AM

Thank You Very Much
Above Code Forces Selection To The LAst Record In The List Box

One More Query !
Can I Change The Color Of The Selection Bar,
By Default Its Black,
Without Changing the Back Color Of The List Box

Thank You In Advance

Larry Larsen

Dec 10 2007, 06:35 AM

Hi
Sorry no..

wkalo

Dec 10 2007, 06:35 AM

Thank You

Larry Larsen

Dec 10 2007, 06:39 AM

Hi
If you would like to try Candace Tripp has an alternative option which does include colour when trying to mimic the control (listbox)..
Check it out: Colour List Box

QUOTE

This demonstrates how to use a subform as a "faux" list box to simulate colored rows.

HTH's

wkalo

Dec 10 2007, 06:42 AM

Thank You I Will Check It Out

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.