List Box format Question

[Bob V]

Is it possible to code a list box if 7th Column shows "e" then that line
turns yellow??
Thanks for any help...............Bob
[lstModify].[column](6)="e" then color Yellow

 

[Pat Hartman]

Not with versions of Access earlier than A2007. Listboxes have only a
single set of properties but I think you can alternate row colors with
A2007. I don't think you can highlight specific rows, you'd need to check.

 

[Bob V]

Thanks Pat ,I was running 2002 version, you still think you could VB code it
some how........Thanks Bob

Not with versions of Access earlier than A2007. Listboxes have only a
single set of properties but I think you can alternate row colors with
A2007. I don't think you can highlight specific rows, you'd need to
check.

Is it possible to code a list box if 7th Column shows "e" then that line
turns yellow??
Thanks for any help...............Bob
[lstModify].[column](6)="e" then color Yellow

 

[Stephen Lebans]

No.
An alternative is to create a Subform to resemble a ListBox and apply
Conditional Formatting to achieve the desired look. Arvin has a sample on
his web site here:
http://www.datastrat.com/Download2.html
Specifically:
http://www.datastrat.com/Download/SubformDemo.zip

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.