ComboBox - display values with different background colors (1 Viewer)

[Blancorn]

I would like to ask you really interesting question:

Is it possible to have values in ComboBox displayed with different background?
For example: having list of values from 0 to 500, values grater than 100 are with blue background and all the others with red one?

 

[Micron]

Pretty sure the answer is no. If memory serves, I may have seen this done for listboxes, but then again, the old noodle ain't what she use to be.
You could change the control colour based on selection if that helps.

 

[vba_php]

the question is not whether IF you can do this, but WHY? Is it because your users are bored or want some flashy interface? combo boxes are meant to be boring. there IS a way to produce events behind the KEYPRESS event when typing inside a box like this. which is similar to the ONBLUR() event in HTML.

 

[MajP]

If you absolutely needed to do this you can fake it, but not with a standard combobox.

That is done with a listview, and unless your VBA is excellent I would recommend bagging it.

This is done with an imageCombo. Did not know it even existed until someone asked a question about it.

 

[vba_php]

If you absolutely needed to do this you can fake it, but not with a standard combobox.

not recommended, wise one.

 

[Micron]

This is probably what I was thinking of

ListBoxEnhanced

VB ListBox

and if you are a UA member, there is something here, but I can't download it so I have no idea what it looks like.

UtterAccess.com

www.utteraccess.com

 

[MajP]

Give it a try but do not hold your breath. I find a lot of the old Lebans stuff (all API based) no longer work even if updated to 64bit. If it needs to be updated to 64 bit there are a few people here that are good at that (I am not one of them).

 

[HiTechCoach]

The way I get around the limits of the standard combo box is to use a form with the view set to Continuous Forms. This allows the use of alternate row colors and conditional formatting.

I use a button with an arrow pointing up (reverse of the combo box arrow) I call this a pop-up, or <grin>"throw up"</grin>, as opposed to a dropdown. On the button click, a pop up form opens allowing the user to make a selection from the list.
It uses standard/built-in Access objects and limited VBA code.

I started doing this with Access 2000 for large lists in combo boxes to speed up form load time. It also overcomes the row limit a combo box can handle. I can also add additional search/filtering for other fields to make it even faster for the user to find something in a long list.
I also have used a subform in place of a Listbox for the same reasons.

 

[vba_php]

The way I get around the limits of the standard combo box is to use a form with the view set to Continuous Forms. This allows the use of alternate row colors and conditional formatting.

to this point, I have the attached zip file stored in a directory that has a last modified date of 15 years ago. maybe they can get something from this as well. it highlights every other row of a report as a continuous view, like what you've said.

 

[CJ_London]

I'm with Boyd, I use a form - but rather than conditional formatting I use rich text for colour/font/bold etc

 

[HiTechCoach]

I'm with Boyd, I use a form - but rather than conditional formatting I use rich text for colour/font/bold etc

I like your thinking. Great use of the Rich Text feature

I have created a custom message box using Rich Text with great results.

I like your idea to use it Rich Text to format text on a form when conditional formatting is just not enough.

I have Access application with many features, like what I described above, that were built with Access 97/200/2002/2003 that are still in use today with Access 2007 and later.

Time to starting updating and rebuilding ...

 

[CJ_London]

when conditional formatting is just not enough.

and too slow - when scrolling conditional formatting does not refresh until you stop scrolling. Only thing you can't do with rich text is disable.

I also use the format property to create a check box which is also resizeable and can use faces rather than ticks and crosses - see this link

use a textbox as a resizeable and colourful checkbox

For whatever reason, checkbox controls cannot be resized. This suggestion addresses that issue and also enables the use of colour. To create, put the following in the format property of a textbox and set the control source to a boolean value 1. set format property -...

www.access-programmers.co.uk

 

[Micron]

Did anyone consider formatting fore color in the table property instead (not for combos or listboxes, but some of this other stuff that's being mentioned)? Not that you would do this where there are more than 1 or 2 conditions I suppose.

 

[CJ_London]

with numbers you have 4 format options as outlined in the link I provided. Dates and text can only have two formats - is not null and is null.

I use it for required fields e.g. for text

@;"Required"

or perhaps

@;[Red]"Enter your name"

The colour options for format are limited and quite vivid, So I might combine with conditional formatting to show grey text when the rule is 'value is null' but tend to only do this on single forms.

 

[HiTechCoach]

and too slow - when scrolling conditional formatting does not refresh until you stop scrolling.

Great point about how slow the conditional formatting can be.