Access Colour Question

  • Thread starter Thread starter Darren Hunter
  • Start date Start date
D

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
 
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
 
I am using Access 97.
Sandra Daigle said:
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.


Darren said:
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
Click to expand...
Click to expand...
 
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.


Darren said:
I am using Access 97.
Sandra Daigle said:
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.


Darren said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top