Access Colour Question

[Darren Hunter]

I have a form that I need to change the colour on some text boxes depending
on the data stored in the DB if the value is 0 then it want to be
transparent, if there is a -1 in the database then I need it to be displayed
in red, the problem I have is that the data I am trying to display is in
details section of the form it for X number of enginers over N days so i
need some code or a way to control the text box directley so do ehat I need
it to do.

Ta
Darren

 

[Sandra Daigle]

Hi Darren,

Take a look at conditional formatting (Access 2000-2002). This feature
allows you to specify upto 3 conditions and formatting options for when the
each of the conditions is met.

To use, select the control, click Format, Conditional Formatting. Check the
help for more details.

CF is somewhat limited in what it can do but it is useful for many
situations. Stephen Lebans has put together a sample database demonstrating
some ways to use Conditional Formatting:
http://www.lebans.com/conditionalformatting.htm

 

[Darren Hunter]

I am using Access 97.

Hi Darren,

Take a look at conditional formatting (Access 2000-2002). This feature
allows you to specify upto 3 conditions and formatting options for when the
each of the conditions is met.

To use, select the control, click Format, Conditional Formatting. Check the
help for more details.

CF is somewhat limited in what it can do but it is useful for many
situations. Stephen Lebans has put together a sample database demonstrating
some ways to use Conditional Formatting:
http://www.lebans.com/conditionalformatting.htm



--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I have a form that I need to change the colour on some text boxes
depending on the data stored in the DB if the value is 0 then it want
to be transparent, if there is a -1 in the database then I need it to
be displayed in red, the problem I have is that the data I am trying
to display is in details section of the form it for X number of
enginers over N days so i need some code or a way to control the text
box directley so do ehat I need it to do.

Ta
Darren

 

[Sandra Daigle]

Ok - then this should work for you instead:

http://www.lebans.com/formatbycriteria.htm

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I am using Access 97.

Hi Darren,

Take a look at conditional formatting (Access 2000-2002). This
feature allows you to specify upto 3 conditions and formatting
options for when the each of the conditions is met.

To use, select the control, click Format, Conditional Formatting.
Check the help for more details.

CF is somewhat limited in what it can do but it is useful for many
situations. Stephen Lebans has put together a sample database
demonstrating some ways to use Conditional Formatting:
http://www.lebans.com/conditionalformatting.htm



--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I have a form that I need to change the colour on some text boxes
depending on the data stored in the DB if the value is 0 then it
want to be transparent, if there is a -1 in the database then I
need it to be displayed in red, the problem I have is that the data
I am trying to display is in details section of the form it for X
number of enginers over N days so i need some code or a way to
control the text box directley so do ehat I need it to do.

Ta
Darren