Access - Disable OnClick Event for a row that has been

Anonymous
2016-04-14T22:02:48+00:00

I would like to use conditional formatting to disable specific rows (rows where Item=Note in the datasheet below). The problem is that I want certain fields of the same row to have their OnClick event disabled. I thought I could just add an If item.Enabled=True guard in the OnClick event handler; however, the row that comes back is not that being clicked on (because it is disabled) and rather the last active row. So, I have no way to programmatically ignore the Click.

Excluding the fields where I don't want the click to be activated allows me to do this check. But, it makes for an ugly checkerboard (see below). Advice?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes