Another colour for a selected Value in a textbox

[francisvandergr]

I have a table called Businessunit with the following values C, E, P, S , ALL. On my dasboard i first had a listbox from the field BU. But my problem is that i don't wanna see all values to select. The value 'ALL' i don't wanna see.

To achieve this i made a few Textboxes with the action "Select in field" BU with the search string C, S,E and P. Now i want one thing in my textbox. I want to have my selected text another colour when i select a value is this possible?

[#2]

Hi,

In this case, I would suggest you to add caption to your Text box.

You will find it in Text box properties - Caption.

You can change color of Active and Inactive Caption as per your choice.

Happy Thoughts

[marcel_olmo]

Sure Francis, all you have to do is calculate the background color depending on your selection or whatever you want to do.

I've uploaded an example showing how to change the background color.

Hope it helps!!

[#4 · Accepted solution]

Hello Francis,

did you try to create an expression within your listbox ? Here is my example:

=if( BU<> 'ALL', BU)

Regards, Roland

[francisvandergr]

In a listbox you can use an expression? I see not on which tab and field i can do that.

[#6]

Yes.

General Tab --> Field input --> search a little bit (it is the first entry of the drop down list and called <expression> ). The rest should be easy.Don't forget the "=" at the begining of your expression.

RR

[maneshkhottcpl]

Hi, Can u explain me in details. if possible please send me sample application.

[francisvandergr]

Thanx i found it