MS Access Highlight Row In Continuous Form

[@darrellhodge1713]

This is awesome! Thank you. I use to teach this stuff. This would have been great to show my students. I am retired now due to a stroke and memory loss. I am getting back into this stuff just to exercise my brain and I am excited by this. Again, thank you.

[@faroe2k9]

Thank you for this little tutorial. Simple and elegant. I used this with a bookmark when open a form and highlights the relevant data from a continuos subform.

[@adelaidekusorgbor1561]

Great tutorial. Am adding this functionality to all my forms. And it's powerful. Thanks

[@davegoodo3603]

Thanks for the great video Jack. Good content, I'd like to see some more Access VBA videos. Good luck with it.

[@gustavoalvesnunes]

Thank you for this little tutorial.

[@dreamsneaimy5320]

thank you so much

[@mera479]

This worked perfectly! thank you!!

[@lisacalhoun306]

Super helpful! Thanks!

[@scrossen778]

For starters where is your StateID field since I didn't see it displayed on the form? However, to keep the user from clicking in txtHighligher, you can set the Data/Locked property to Yes and TabStop to No. This will keep it from ever getting the focus. Also is the Me command not necessary when referring to a control on the current form? When I write code I can't get my control names to autolist without it. Please help me out with what you are showing at 5:15 & 7:50.

[@sashafroyland]

Nice Job! Very helpful. Microsoft Access UI super powerful and relatively easy to code. Can you imagine doing this in another programming language? Crazy. MS Access is at least 4x faster to implement an intuitive user interface design than any other programming language.
However, when you need to scale, the platform becomes brittle. Google "microsoft access migration services Help4Access" for some case studies and videos how to migrate all or just a portion of MS Access functionality to other technologies.

[@jevgenijobzigailov2376]

For Microsoft it is much more profitable to sell technology stacks through network of partners (pay for SQL Server / IIS configuration, pay for Visual Studio, pay for expensive trainings) rather than simple self-service one-stop solution, that's why they killed FoxPro and not developing Access anymore.

[@sara_whyamihere53]

This works great IF the field value is unique to one row. What if the data you're using is indexed using multiple fields?

[@taribo73]

why if I save as .accde doesn't work? any idea?

[@kennethwright65]

All my rows turn yellow, not just the selected. Any idea why?

[@richardnguyenduong]

StateID is not specified?

[@richardnguyenduong]

FWD from author comment:
Hi... but below are the couple lines of code from this video. [txtCurrentRecordID] is the hidden field on the form that will hold the current record's [StateID]; which is then referenced by the conditional format we created on the [txtHighlighter] textbox. Hope that helps.
Private Sub Form_Current()
txtCurrentRecordID = StateID
End Sub
Private Sub txtHighlighter_Enter()
StateName.SetFocus
End Sub

[@kennethwright65]

@@richardnguyenduong Yes it is specified.

[@richardnguyenduong]

I set conditional formatting for the highlighter textbox, and give a field of continuous form equal to a specific value, then it works selectively as expected.

[@kennethwright65]

@@richardnguyenduong Yes I did all that, I followed the video step by step more then once, and still all my rows turn yellow.

[@akashtribhuvan8124]

Great

[@emilymccreery8221]

Could you please post the vba code, I can not see it. Thank you

[@trycatchthrow-codingtipsan1524]

Hi Emily, Sorry I saw this comment a week later... but below are the couple lines of code from this video. [txtCurrentRecordID] is the hidden field on the form that will hold the current record's [StateID]; which is then referenced by the conditional format we created on the [txtHighlighter] textbox. Hope that helps.
Private Sub Form_Current()
txtCurrentRecordID = StateID
End Sub
Private Sub txtHighlighter_Enter()
StateName.SetFocus
End Sub

[@malcolmdavidson6254]

For people learning Access for the first time, you go far too quickly through what needs to be done. You make assumptions about the knowledge that people have. Every small detail should be explained. It's taking me a long time to figure this all out. When you know how to ride a bike it's tough to remember that some folks do not know how to. That is the perspective you should start from.