colours in query

[emcloa]

We have an output of query

lengte MAKTX: Len([maktx]) But waht we also want to have is that when the LEN > 40 that it is displayed in an other colour !
But i have tried several things... ... i cannot find it.


In excel this is very simple but is this possible in access ????

[alansidman]

Conditional formatting is available in Access but only in Forms and Reports. It is not something you can do in a query. In a report or form, right click on the control and select conditional formatting.

[emcloa]

I have tried to make it with conditioanal formatmatting

But can you help me wiht the codeing? (in the form)
I tried with Expression is : Len([PRDHA]=15) >> and selecting green colour.... but i think i have to use a little bit more a more sophisticated expression?

[Bob Fitz]

Not sure about this but try:
Len(Forms![YourFormName].[PRDHA]=15)

[emcloa]

hmmmm can you try? here it doesnot workl... and i think it should be so simple!

[Bob Fitz]

Can you show uss the expression you are using.

[emcloa]

I have attached.

hope this explains.
Driek

[Bob Fitz]

I'm guessing that the file you attached is a screenshot and that you are using A2007 or A2010. I don't use either of those versions so I can't be sure but I think you are using: Len([PRDHA]=15)

I think you should be using: Len(Forms![YourFormName].[PRDHA]=15)
Change YourFormName with the name of your form.