How do you reference controls record by record on a form that displays many
I've created a form with a detail section that displays all records from a
table. In code, when I reference a control and its properties in the
details section (e.g. Address1.ForeColor), it affects ALL Address1
textboxes. If I change the forecolor for Address1, all 10 or 20 or however
many records there are, get affected. How do you refer to Address1 for any
Also, is there an event that fires repeatedly when the form shows all
Please don't tell me to use Conditional Formatting as that doesn't apply to
all controls plus doesn't give me enough flexibility for what I want to do.
This should be pretty simple for someone used to coding Access VBA (I'm new
to it but old at VB in general!). Any help at all that gets me looking in
the right direction would be greatly appreciated.