By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,681 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

manipulate controls on current record of a form

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.