Colors and Listboxes.

A

Adrian Brown

From what i can read It turns out that Access 2003 is still limited when it
comes to this, but i thought id double check. I have a multi column listbox
on a form and I want to be able to change the colour of single row - Is this
possible in any way (even writing ocx controls if i REALLY have to)

Many Thanks
 
S

Stephen Lebans

Sorry the answer is still no.
Instead use a Subform with CF formatted to resemble a ListBox control.

--

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

Adrian Brown

Im happy to use a sub form - its just a sub-set of a single table, how do
you go about CF formatting - i havent really explored that sort of thing
fully yet.

Adrian
 
S

Stephen Lebans

Look up Conditional Formatting in:

1) The Help Files

2) On GoogleGroups:
http://groups-beta.google.com/groups?hl=en&lr=&ie=UTF-8&safe=off&num=100
&q=Conditional+Formatting+group%3A*Access&safe=off

3) Basic CF stuff:
http://www.rogersaccesslibrary.com/TableOfContents3.asp

4) CF to make a Form resemble a Listbox:
http://www.datastrat.com/Download2.html

5) Two good MS KB articles on CF:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k
2/html/odc_conformat.asp
AND
http://support.microsoft.com/default.aspx?scid=kb;en-us;304104

6) Some other MS KB articles on CF:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000
/html/actbccolororotherformatsautomaticallychangewhenidontexpectit.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000
/html/acconaboutconditionalformattingonform.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;210263

Change the format of a text box or other control on a form or report
when it meets certain criteria
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000
/html/achowchangeformatofvalueincontrolwhenitmeetscertaincriteria.asp



7) Some advanced CF samples here:
http://www.lebans.com/conditionalformatting.htm
--

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

Adrian Brown

Many Thanks


Stephen Lebans said:
Look up Conditional Formatting in:

1) The Help Files

2) On GoogleGroups:
http://groups-beta.google.com/groups?hl=en&lr=&ie=UTF-8&safe=off&num=100
&q=Conditional+Formatting+group%3A*Access&safe=off

3) Basic CF stuff:
http://www.rogersaccesslibrary.com/TableOfContents3.asp

4) CF to make a Form resemble a Listbox:
http://www.datastrat.com/Download2.html

5) Two good MS KB articles on CF:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k
2/html/odc_conformat.asp
AND
http://support.microsoft.com/default.aspx?scid=kb;en-us;304104

6) Some other MS KB articles on CF:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000
/html/actbccolororotherformatsautomaticallychangewhenidontexpectit.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000
/html/acconaboutconditionalformattingonform.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;210263

Change the format of a text box or other control on a form or report
when it meets certain criteria
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000
/html/achowchangeformatofvalueincontrolwhenitmeetscertaincriteria.asp



7) Some advanced CF samples here:
http://www.lebans.com/conditionalformatting.htm
--

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