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,
Dec 10 2007, 06:25 AM
Me.YourLstboxName = Me.YourLstboxName.Column(0, Me.YourLstboxName.ListCount - 1)
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
Dec 10 2007, 06:39 AM
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
This demonstrates how to use a subform as a "faux" list box to simulate colored rows.
Dec 10 2007, 06:42 AM
Thank You I Will Check It Out