Conditional Formatting Greyed Out; Do not know why?

[Datamulcher]

I have made a productivity form with a field which displays the trend as either "Down" or "Up!".
I would like it to be conditionally formatted to GREEN if UP and RED if DOWN, but the conditional formatting button is greyed out for this field.
[note- it is greyed out for all fields except for the date field...]

The box is a ListBox, pulling data with Row Source: SELECT [qDB_Trend].[Trend] FROM qDB_Trend ORDER BY [Trend]; and RowSourceType of Table/Query.

I have scoured the internet but there are no answers I have found. The only thing I have found out is that ListBoxes apparently are not able to be conditionally formatted.
I tried using a ComboBox and it will display the data, buuuuuuuuuuuut cannot apply CF to this either!

I am still learning so have mercy, I tried using other box types, but these do not have a "Row Source" field, only a control source - and placing the above SELECT statement in these either gives me a #NAME error or just blank.

So- A) Can I apply CF to a listbox? B) if not, how can I use another type of box to display the data from a query as above?

Thanks in advance!!

[aytee111]

As this box only contains one value, it need not be a listbox (which displays a list of items). This also sounds like a display field, not one that the user selects - is that right? In that case you could have 2 label fields, one red and one green, and make them visible/invisible for whichever value is being displayed.

[Datamulcher]

Yes you're right, it is only a display field.

The reason I have it as a listbox is that if I ask another type of box to display the data from SELECT [qDB_Trend].[Trend] FROM qDB_Trend ORDER BY [Trend]; (the value from the query I want displayed) it just displays either blank or NAME#. I'm relatively new to Forms so I don't know the criteria for the use of the different box types well.

I do not know what you mean by "have 2 label fields, one red and one green, and make them visible/invisible for whichever value is being displayed." - sounds good, but how is that implemented?

[aytee111]

What is the record source for your form? If you join this query to it then it will be a textbox bound to the record source. Then you can set the conditional formatting.

[andy49]

If the info isn't in your record source (and you can't add it) you could use a dlookup statement

Dlookup ("trend","qdb_trend", criteria)

This would put the up or down in a textbox and you could use conditional formatting from there.


Sent from my iPhone using Tapatalk

[Missinglinq]

The reason I have it as a listbox is that if I ask another type of box to display the data from SELECT [qDB_Trend].[Trend] FROM qDB_Trend ORDER BY [Trend]; (the value from the query I want displayed) it just displays either blank or NAME#.

That's correct! andy49's suggestion is the only way to display a value from a Query in a Textbox...you can't simply assign it with a Query/SQL Statement.

Linq ;0)>