I am making a function with border color auto changes:
Code:
'makes fields red that need to be completed
Public Function tagMustComplete(TagName As String, FormImport As Form, DefaultBorderColour As Long) As String
Dim ctl As Control
For Each ctl In FormImport.Controls
Select Case ctl.ControlType
Case acComboBox, acTextBox
If ctl.Tag = TagName Then
If IsNull(ctl) = True Then
.BorderColor = 2366701
Else
.BorderColor = DefaultBorderColour
End If
End If
End Select
Next ctl
End Function
however control doesn't have the property .bordercolor and I need to change the borders for the accombo boxes and actextboxes - how do I refer to them to change the property?