Highlight Record in Continuous Subform
- Thread starter Thales750
- Start date
- Local time
- Today, 13:29
- Joined
- Feb 19, 2013
- Messages
- 17,756
depends on whether the subform is a continuous form or a datasheet as to which control(s) you use
in principle you will need to use conditional formatting to set the back color. And then you need to somehow identify which record the mouse is over at that time
One way is to determine how far down the subform the mouse is and dividing that by the detail section height. Assuming the form isn’t scrolled that will be your absolute position which you can then use to find the id of the record by referencing the recordset clone.
code would then populate a hidden text box with the id and you would use a conditional formatting rule for the record controls along the lines of
expression is….[id]=[txthidden]
if the subform is scrollable you will need additional code to determine the scroll position, which then needs to be combined with the above code to determine the absolute position
i can’t point to any examples - it can be done, but it is a lot of work
in principle you will need to use conditional formatting to set the back color. And then you need to somehow identify which record the mouse is over at that time
One way is to determine how far down the subform the mouse is and dividing that by the detail section height. Assuming the form isn’t scrolled that will be your absolute position which you can then use to find the id of the record by referencing the recordset clone.
code would then populate a hidden text box with the id and you would use a conditional formatting rule for the record controls along the lines of
expression is….[id]=[txthidden]
if the subform is scrollable you will need additional code to determine the scroll position, which then needs to be combined with the above code to determine the absolute position
i can’t point to any examples - it can be done, but it is a lot of work
isladogs
Access MVP / VIP
- Local time
- Today, 13:29
- Joined
- Jan 14, 2017
- Messages
- 19,332
I agree with all the comments in the previous reply
However, I have an example for a highlighting a record on a listbox as mouseover which you may be able to adapt
www.isladogs.co.uk
This is only a small part of that article. The parts relevant to this discussion are Forms 4 & 5
However, I have an example for a highlighting a record on a listbox as mouseover which you may be able to adapt
Accurately Move Forms & Controls
This article demonstrates how to accurately move forms & controls based on the various units of measurement used in Windows applications (pixels, points and twips) together with the little known and undocumented VBA Wizhook function
www.isladogs.co.uk
This is only a small part of that article. The parts relevant to this discussion are Forms 4 & 5
Thanks Guys,
What's interesting in a sort of a, step on a Lego piece kind of way, is that the opening page of Access has this exact method for selecting which Database you want to open.
We are a bunch of neglected misfits in the computer world. I'm just going to put a button with Hover Color at the left of the record. It will work well enough.
What's interesting in a sort of a, step on a Lego piece kind of way, is that the opening page of Access has this exact method for selecting which Database you want to open.
We are a bunch of neglected misfits in the computer world. I'm just going to put a button with Hover Color at the left of the record. It will work well enough.
I am aware of that. Years ago, web design was decades behind the Access UI. The whole world changed, evolved actually, but not Access. Luckily we have the AI to help us build things we don't know how to code.
Thanks for trying to help.
Yes thanks, I have the highlighted record for a decade or so. I adding CRM to my project management program and just trying to make it modern.
This is probably a good time to see how I can utilize the AIs out there. Time for the old guy to see if the brain has any flex left in it.
Thanks for the help, what you guys do is so appreciated.