Use Fontbold in a list of combobox

[angybab]

Hi all,
I have a list of items in a combobox having two columns. The first column contain the codes (3 and 5 digit codes) the second column contains the text describing the code. I want the rows containing the 3 digit codes to have a Font bold. Is it possible to use a vba code to set that in access?

lets say; this is the list of contents in the combox "cboMainSubkat" (the list source is from a table)

code meaning
A01 Main kategory for all A01's
A01.2 Sub kategory
B01 Main kategory for all B01's
B01.3 Sub kategory



I want all rows with 3 digit codes to be bold. I will appreciate any help.

thanks

[Bob Fitz]

AFAIK that's not possible.

You might be able to get a similar effect using a hidden subform, a button and a textbox but I think it would take a bit of time and patience. I have a vague recollection of seeing somebody's attempt at this but I have no idea now of when or where that was or even if it worked.

[isladogs]

Agree with Bob.
You can do limited formatting in combo boxes but not what you want.
To get an idea of what can be done, see http://www.mendipdatasystems.co.uk/a...our/4594424152

[Micron]

IIRC a listbox can have such formatting, so you would have to resort to some trickery to make a listbox emulate a combobox along with a button to "drop down" the listbox. However, the list has to be bound to a RTF table field and the text formatted as you wish. I do not believe you can easily make that text formatted on the fly.

[isladogs]

The link in post #3 also covers formatting in listboxes.
AFAIAA, you cannot do anything significant regarding formatting in a listbox compared to a combobox
However, happy to be proved wrong ....

[Micron]

However, happy to be proved wrong

Not much chance of that. Whatever I had that I vaguely recall has been lost as you probably know. Perhaps it was a visual trick that I employed, but I seem to recall that I had what looked like a listbox with multi-coloured fonts. I will have to defer to the conventional wisdom and admit defeat.

[isladogs]

Ha!
This is from the link I gave in post #3:



No trickery. Just formatting of null/not null in the Field2 column - it works for text fields only

Was that what you were thinking of perchance?

[June7]

Not according to how I read OP's question.

My understanding is they want rows with A01 and B01 to be bold. This goes well beyond Null/NotNull.

[Micron]

Thanks, that must have been it because I did implement that. I didn't follow the link at first because I interpreted your post as being for a combo box.

[CJ_London]

only way is to use a subform using conditional formatting. in combination with a textbox you can use code to make it look and behave like a combo. Note this method is not suitable for continuous forms. It can be done, but is a lot more work.

Don't have time to provide the code right now but in principle

in design view, place subform directly below bottom of text box to a width to suit
in form load event set subform height to 0
in textbox gotfocus event, set subform height to something appropriate
in textbox change event apply a 'find' to find the first record that matches what is being typed

in subform current event populate the parent form textbox with the value selected then reduce the subform height to 0

and of course in subform set conditional formatting to something like

expression is....len([CODE])=3

[isladogs]

Not according to how I read OP's question.

My understanding is they want rows with A01 and B01 to be bold. This goes well beyond Null/NotNull.

That was exactly the point I made from the start! The formatting that can be done with combos or listboxes isn't what the OP wants

[accesstos]

Hi everybody!

I often use simple forms as useful lists and I have to say that is not as hard as it seems to make a form to simulate a drop-down list, but, I think it demands more work to replace it completely.

I attach a sample project, with two combo boxes in a main form that use the same hidden pop-up form as drop-down list and I think that the results is close to the desired.



Forms give us the ability to create well designed lists with additional information for each item, like images, symbols, conditional formats, hyperlinks etc.

I hope it helps.

Cheers,
John

[Micron]

Sure OP, who is not one of the last 11 posters, said bold. Sometimes when you present options they are deemed acceptable. I wouldn't get too hung up on pointing out what OP wants based on one post and no follow up.

[June7]

@accesstos, sample db was driving me nuts trying to understand what was happening until I caught your description this uses a popup form. Really becomes obvious after switching to Overlapping Windows which is my usual preference. Had to make adjustment to the Left and Top calculations for popup form placement.

[angybab]

This seems to be a very complicated issue