is anyone else having this issue?
The application either hangs or crashes.
After days of trying to identify the issue...
Exported the form that caused the crash to text and back. Didn't fix.
I wrote a procedure to list all the controls on a form together with a list of their properties.
Then I wrote a procedure to add the controls to a new form and set their properties
But I didn’t put the conditional formatting back.
This did fix it.
But then another form crashed.
I ran this
Dim frm As Form
Dim ctl As control
Dim strFormName As String
strFormName = "frmWhatever"
DoCmd.OpenForm strFormName, acDesign
Set frm = Forms(strFormName)
For Each ctl In frm.Controls
If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Then
DoCmd.Close acForm, strFormName, acSaveYes
Seems to have resolved the crashing.
So far no other forms are causing a crash.
There is no error message. Just either hangs or crashes.