Managed to solve this in the end but the solution wasn't pretty.
So if we know a combo box list does contain trailing spaces we have to add it to the list in this function along with the field size and space fill it so it can find the value in the combo box.
Code:
Private Function fstrComboSpace(pstrDialog, pstrObject, pstrData)
Dim strComboSpace
Dim intComboSpace
strComboSpace = pstrData
intComboSpace = 0
Select Case pstrDialog
Case "Maintain Deal Requirements"
Select Case pstrObject
Case "Requirement" intComboSpace = 35
End Select
End Select
If intComboSpace > 0 Then
intComboSpace = intComboSpace - len(strComboSpace)
strComboSpace = strComboSpace & space(intComboSpace)
End If
fstrComboSpace = strComboSpace
End FunctionSo if we know a combo box list does contain trailing spaces we have to add it to the list in this function along with the field size and space fill it so it can find the value in the combo box.
