MS Access: How can I control the properties of a specific record of a continuous form within a subform?

Question

I'm working on an Access application that has a form with a subform. The subform contains data about the various stages of the main form. Each stage is sequential; that is, after step 1 comes step 2, and there is no overlapping of stages.

I want to have ONLY the current stage's data (of the continuous subform) boldfaced. I know how to turn on the boldface font for all the records (using a macro & setvalue). I don't know how to select a record and boldface only that record in a continuous subform.

Thanks for your help.

Answer 1

Access has Conditional formatting:

Open the form in design view, select the control, and click on Format (in the menu bar), Conditional Formatting.

That may or may not help you.

Otherwise, there is no way that the properties of one box can be made different to the proerties of the other boxes in a continuous form by using VBA.

HTH