Access lock controls on form

AWRjason 1 Reputation point
2022-10-30T13:23:49.157+00:00

I am using Allen Browne's code to lock bound controls to minimize the chances of users overwriting data when they are only viewing records. The handy code is here:

http://allenbrowne.com/ser-56.html

The problem is that the first field is highlighted as if selected on each subform when locking the form which is very confusing for the user because it isn't clear where they are on the form.

Any ideas on how to prevent highlighting? I attached a screenshot showing the problem.255404-screenshot-2022-10-30-091816.jpg

Microsoft 365 and Office | Access | Development
0 comments No comments
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.