Listbox background

[mafhobb]

Is there any way to make a listbox background transparent? I can't find this property in the property list.

I basically want no background (or border, which I have already removed) or a background that is the same color as the form.

Thanks

mafhobb

 

[John Big Booty]

There is no BackStyle property for List Boxes. The best I can think of is the set the BackColor to match the colour of the form, and set the SpecialEffect to Flat and BorderStyle and Color as required.

 

[mafhobb]

Hi John, that is what I am trying to do, but I can't figure out what is the color of the form behind as it has no color property listed...it is the typical greyish color the most windows are, but I do not know what color code it is.

Mafhobb

 

[John Big Booty]

try (-2147483633)

 

[missinglinq]

What John did, and anyone can do who needs to find out the color value of a given object, is to select the object, in this case probably the Detail Section of the Form then go to Properties - Format and look at the Back Color Property. Then simply Copy and Paste it into the target object's Back Color Property.

Linq ;0)>

 

[mafhobb]

What if it says "System Button Face"" How do you relate that to an actual code you can use elsewhere?

mafhobb

 

[Moses76]

There is no BackStyle property for List Boxes. The best I can think of is the set the BackColor to match the colour of the form, and set the SpecialEffect to Flat and BorderStyle and Color as required.

My listbox displays multiple rows and columns . I want to change the color of the row in which on column says "vacation" . How can I do that ?

please help

 

[John Big Booty]

My listbox displays multiple rows and columns . I want to change the color of the row in which on column says "vacation" . How can I do that ?

please help

I'm not sure it's possible. However you may be able to do it using a variation on the theme displayed in the attached sample.

The sample is a Pseudo Drop Down Box, originally posted by ChrisO

 

[missinglinq]

John is correct! You're not going to be able to do this with a native Access Listbox. Hopefully his suggestion may point you in the right direction, although I have to say that this kind of effort, geared towards a purely cosmetic effect like this is, in my opinion, not worth the effort!

Linq ;0)>

 

[John Big Booty]

..., although I have to say that this kind of effort, geared towards a purely cosmetic effect like this is, in my opinion, not worth the effort!

Linq ;0)>

Agreed.

Perhaps a continuous Sub-Form in data sheet mode, with some Conditional formatting might provide a satisfactory facsimile.