Fix Bug - InStr And InStrRev
InStr or InStrRev function results in error or crashes database if sort order is “General”).
Work around: Options > General > New database sort order > General - Legacy’, followed by ‘compact database’.
The behaviour is very odd in that e.g. it may or may not work first time after reboot / logon, but fails subsequently. Compacting and then restarting the database never fixes the issue.
This problem resulted from recent (Quarter 2 to July 2020) Windows and / or Access 2019 updates.

1 comment
-
Colin commented
Thank You! I was puzzled by the sudden crashing caused by the Instr.