Form / Subform (Individual Rows)

[Van T. Dinh]

You need to use Conditional Formatting. This can be done
in the design view of the Subform.

To do this by code, Stephen Lebans has a sample database
on his Web site:

<http://www.lebans.com/conditionalformatting.htm>

HTH
Van T. Dinh
MVP (Access)

 

[Guest]

Van

Thanks, I downloaded the file, and I have to look through it to see how he
uses the class module(s) that are in the database.

George

 

[Guest]

What if you want to do something that Conditional Formatting can't do, such
as populate an unbound field in the same row, or make another field visible,
disabled, etc? Is there a way to programmatically modify just the current
row's controls?

 

[Van T. Dinh]

No. What you see is many instances of the same Control, one for each "row",
not different Controls.

 

[Guest]

So just to be clear, there is no way to programatically alter the properties
of a particular instance of a control on a continuous form.

For example i have a continuous form that displays a list of products and
the quantaties of them in stock. I can use conditional formatting to make
the colour of text in the qty feild go red if it is smaller that the value
in the reorder level feild but conditional formatting can't be used to make
the text in the description field go red if the qty field is smaller than the
reorder level field and therefore it can not be done at all.

 

[Guest]

So just to be clear, there is no way to programatically alter the properties
of a particular instance of a control on a continuous form.

For example i have a continuous form that displays a list of products and
the quantaties of them in stock. I can use conditional formatting to make
the colour of text in the qty feild go red if it is smaller that the value
in the reorder level feild but conditional formatting can't be used to make
the text in the description field go red if the qty field is smaller than the
reorder level field and therefore it can not be done at all.

 

[Van T. Dinh]

I am fairly sure that you can use Conditional Formatting for what you
described.

What you need to do is to set the Conditional Formatting on the
"Description" Control and in this, use the Qty Field in the criterion.

--
HTH
Van T. Dinh
MVP (Access)