Counting Coloured Textboxes

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

Guest

I have a series of textboxes which have been programmed with an IF Statement
saything that if they are greater than a certain date to shade them a certain
colour, say Red.

I would like to know whether or not there is a way inwhich I can have 1
textbox seperate form which calculates the total number of Red textboxes
providing me with a brief summary.

Any help would be appreviated
 
Kieron,

I am not sure about counting textboxes based on code-modified colour.
It would probably be easier to count them based on the same "greater
than a certain date" criteria that you used to effect the colour
manipulation. To do this, you can put an unbound textbox in the Footer
or Header section of the report, with its Control Source property set to
the equivalent of...
=Abs(Sum([YourDateField]>#2/04/2006#))
 
Hi,

Thanks for your help Steve. What you suggested has worked in terms of
counting coloured textboxes however, as I have structured the Abs statement
around certain text and then applied conditional formatting around the text
to provide me with a colour.
However, I have 350 entries in my database with a variety of different forms
which apply filters to reduce the number of entries making it more relevant
to the user. What I am looking for now is to add a filter to the statement
that you gave me,

=Abs(Sum([YourDateField]>#2/04/2006#)),

which will reduce the count number in line with the number of entries which
are shown whilst the filter has been applied.

If there is anyone who might have a suggestion or even have an answer, I
would be extremely greatful.

Many Thanks In Advance,
Kieron
Steve Schapel said:
Kieron,

I am not sure about counting textboxes based on code-modified colour.
It would probably be easier to count them based on the same "greater
than a certain date" criteria that you used to effect the colour
manipulation. To do this, you can put an unbound textbox in the Footer
or Header section of the report, with its Control Source property set to
the equivalent of...
=Abs(Sum([YourDateField]>#2/04/2006#))

--
Steve Schapel, Microsoft Access MVP

Kieron said:
I have a series of textboxes which have been programmed with an IF Statement
saything that if they are greater than a certain date to shade them a certain
colour, say Red.

I would like to know whether or not there is a way inwhich I can have 1
textbox seperate form which calculates the total number of Red textboxes
providing me with a brief summary.

Any help would be appreviated
Click to expand...
Click to expand...
 
Back
Top