Conditional formatting in MS Access is not working for certain fields on my form. I've searched for answers, tried the answers I've found and am still stuck.
I have a form with approximately 30 controls - some comboboxes and some text boxes (displaying dates). I have applied conditional formatting the the controls so that when the value has been edited it is shown as bold, italic, and with a yellow background. For most of the controls this works as desired. For a small few, which seem to have nothing in common, it does not work.
A possible clue is this - the formula of the condition is:
controlName.value <> controlName.oldvalue
For the controls where the conditional formatting works the formula is displayed in the conditional formatting dialog box exactly as above For the controls where it doesn't work the conditional formatting dialog box translates the formula to:
[controlName].[value] <> [controlName].[oldvalue]
I have tried creating new controls, using the default control name (thinking something may be corrupted with the original) but this doesn't solve the problem. I see the same behavior.
I have tried importing all of my objects into a new database (thinking there may be something corrupted with the database). No joy.
I've also run the debugger on my code and compacted and repaired the database. No change.
One of the fields where conditional formatting does not work is a textbox which displays a date field. The rest are comboboxes. I have other textbox date fields and comboboxes on the same form which work fine.
This is an MS Access 2010 .accdb file with linked tables to a MS SQL server 2016 server. The recordsource for the form is linked table which is a SQL Server view. The linked table has a primary key index.
I don't know what more I can tell you. Has anyone seen this problem?