I was constantly getting a Str Function Not Defined on the new 2020 Windows Update which broke references to my MSCAL.OCX.
String functions and how to use them
With string functions, you can create expressions in Access that manipulate text in a variety of ways. For example, you might want to display only part of a serial number on a form. Or, you might need to join (concatenate) several strings together, such as a last name and a first name. If you’re not savvy with expressions yet, see Build an expression.
If you have been using an old database for quite sometime the new update broke the reference to the MSCAL.OCX. So if you have been using an old database you probably already have the MSCAL.OCX file already installed on your PC and you can skip the installation of the OCX step below.
If not you need to download the MSCAL.OCX
On 64bit you need to add the file to C:\Windows\SysWoW64\
On 32bit you need to add the file to C:\Windows\System32\
Next In Office 365 you need to access the Visual Basic Editor you can do this by :
- Open the database.
- Press ALT+F11 to start Visual Basic Editor.
- On the Tools menu, click References
Once you have the References opened click on Browse and locate your MSCAL.OCX.
Restart the Access 365 and your errors should be resolved.
