Control properties in "continuous" forms view question

[James529]

I am concerned that i have chosen the wrong forum for this question but here goes.

I have a subform that is set up for "continuous forms" viewing of the data. the form is designed to show the user 10 records before they have to scroll to see any additional records.

When the user lands on a particular record in continuous forms view, i would like to be able to access the controls just on the current record, for example, I might wish to make a control change color in a timer event etc. etc.

I tried this and of course what happened was that the control started changing color on every record.

So, here is my question:

In continuous forms view, on a subform, is there a way to access the properties of only the controls of the "current record" ??


P.S. if i have posted in the wrong forum, please forgive me. I do reserve the right to cross post in the vba forum should i not get a response here after some time has passed.
thanks
James

 

[Frink]

Hallo,

Unfortunately (or perhaps fortunately) you can't have different control properties for each record.

If you want to change the colour of data in a record, cast your eyes over these two loverley FAQs:
How do I get different coloured text for records
How do I get different background colours for records

- Frink