Text box Colour

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form in access 97 which has been created in a table format, what I
need is to be able to change the colour of one box if it is greater than the
value in another box.

seemed simple enough used an if statement and this worked but it coloured
all of the boxes, so I put the statement in the on current event of the form
and this did not work either. I believe I may need a loop to check each box
against the each value but I am not sure of how to go about this.

any ideas mucho appreciated
 
Songoku said:
I have a form in access 97 which has been created in a table format, what I
need is to be able to change the colour of one box if it is greater than the
value in another box.

seemed simple enough used an if statement and this worked but it coloured
all of the boxes, so I put the statement in the on current event of the form
and this did not work either. I believe I may need a loop to check each box
against the each value but I am not sure of how to go about this.

any ideas mucho appreciated
Click to expand...

This old, old problem had everyone tearing their hair out with A97 and
earlier. The simplest solution is to upgrade to Access 2000 or later and
use the Conditional Formatting feature.

If that isn't on, you could take a look here, but it's pretty fiddly:

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