manipulate controls on current record of a form

[Paul]

Hi. I'm using Access 2000. I have to construct a form that does the
following. The form displays rows from a query result. One column of
the query has a dollar value in it. Initially, I want that value
hidden, or colored to be hidden. Then, at the click of a button, I
want each value to appear, one row after the other, with a slight
pause inbetween. It would look as if the values were being populated
one by one, by a ghost. Next, at the click of another button, I'd like
code that inspects each dollar value, and if it is >= a certain value,
to change the text color to red. Does anyone have code or can point me
to similar code that can do this? Thanks in advance.

[Steve Jorgensen]

On 30 Dec 2003 10:59:07 -0800, pa**********@cigna.com (Paul) wrote:

Hi. I'm using Access 2000. I have to construct a form that does the
following. The form displays rows from a query result. One column of
the query has a dollar value in it. Initially, I want that value
hidden, or colored to be hidden. Then, at the click of a button, I
want each value to appear, one row after the other, with a slight
pause inbetween. It would look as if the values were being populated
one by one, by a ghost. Next, at the click of another button, I'd like
code that inspects each dollar value, and if it is >= a certain value,
to change the text color to red. Does anyone have code or can point me
to similar code that can do this? Thanks in advance.

Your second question can be handled simpy using conditional formatting. Your
first question can't be handled in Access at all (or not without unreasonable
difficulty) because control properties in Access apply to the control overall,
not to an instance of a control on a particular row.