Conditional formatting (1 Viewer)

Ben_Entrew

Registered User.
Local time
Today, 06:38
Joined
Dec 3, 2013
Messages
177
Hi all,

how can I add a conditional formatting in ACCESS VBA?

Let's say I got a table TEST with a column x.

Is it possible to say color line green if x < 5 , color line red 6<x<10 and color line yellow if x > 11?

Thanks in advance.

Regards,
Ben
 

pr2-eugin

Super Moderator
Local time
Today, 13:38
Joined
Nov 30, 2011
Messages
8,494
By the sound of your description I get that you are using a Continuous form? If so Conditional Formatting using the Design is the only way you can get what you want. If it is a Single Form then it might be a bit excessive coding.
 

Ben_Entrew

Registered User.
Local time
Today, 06:38
Joined
Dec 3, 2013
Messages
177
Hi Paul,

I'm not sure what you mean with continuous form.

I create a report in a Access database using a button in a form called BP.

The report name is TEST.

I just want to add a conditional formatting at the end, so that the USER can identify the issue records more easily.

Kind regards,
Ben
 

Ben_Entrew

Registered User.
Local time
Today, 06:38
Joined
Dec 3, 2013
Messages
177
Hi all,

I still couldn't find a solution. I don't use any form.

Just wanna color a column of a table using a condition.

I got a table Test in my Access Database.

How can I color column x red, when x < 0 and green when x > 0 .

Is this possible?

Thanks.
 

JHB

Have been here a while
Local time
Today, 14:38
Joined
Jun 17, 2012
Messages
7,732
No it is not possible at table level, it is used in forms/reports!
 

Ben_Entrew

Registered User.
Local time
Today, 06:38
Joined
Dec 3, 2013
Messages
177
Thanks for the quick response.

It it possible with Access 2010?

Regards,
Ben
 

JHB

Have been here a while
Local time
Today, 14:38
Joined
Jun 17, 2012
Messages
7,732
Same answer - use a form in datasheet view.
 

Users who are viewing this thread

Top Bottom