List box question

[Jacob]

I have a list box wich contains a list of my customers. Some customers have
the same name with different addresses so they are displayed in there more
than once with a different City listed next to the name. Is there a way to
color the ones that are named the same in the list box? Thanks for any help
anyone can offer.


Jacob

 

[Peter Hibbs]

Jacob,

You cannot change the colors of individual lines on a standard Access
List box. However, if you OK with writing some VBA code you could use
a Flex Grid control, have a look at this site for some examples.

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

HTH

Peter Hibbs.

 

[Jacob]

Thank you Peter, I downloaded this, copied the OCX to my system32 folder and
when I try to open any of the buttons on the switchboard, I get this error
message "Object doesn't support this property or method (Error 438)" Any
clues as to why?


Jacob

 

[Peter Hibbs]

Jacob,

Did you register the control as described in the Installation section
of the attached document? If not, then you need to do that.

Peter Hibbs.

 

[Jacob]

Duhhh Im such a blond...thanks Peter, I will look this over to see if I can
use this instead of my other idea. It may be more trouble than I am ready to
put in to this.