accessing "Current" record property

[James529]

Question,

is there a way code in VB the following:

for the "current record" on a subform which is displayed in continuous forms mode (10 records show concurrently), cause a control to change colors (for ONLY the "current record&quot

I already know how to make a control change color. What i want to know is how to do it ONLY for the current record (record the user has selected or scrolled to). Right now, my code causes the control on every record to change color, that's not what i want.

PS
this was posted in another forum without success so, hope you sticklers don't get all peeved about the cross post;-) k?

James

 

[JimHorton]

James,
THis is an age-old question in Access, and the simple answer is that it can't be done. I know that some may see this as a 'give up' attitude, but let's be real about this. There are dozens of kludges out there which work to one degree or another, but they are all just that-kludges.

In VB, it's a whole different story, with 3rd party grids such as Apex, et. al, but in an Access subform, you're better off to just walk away from that issue.
--Jim

 

[jimmythegeek]

I tend to agree with Jim. However, Dev Ashish has created the best attempt at this I have seen so far. You can find it here:

http://www.mvps.org/access/forms/index.htm

There is an entry for:

"Colors and Continuous forms"

And the one I believe you are looking for:

"Changing the background color of the current record in a continuous form"

You can download samples from there, as well as his notes along with it. This is an excellent site with a ton of information, bookmark it. Dev is a real asset to the Access community. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?