Dear readers
How can I modify textfield.backcolor via a function?
I use
Public Function ChangeColorDropDown(Variable As Variant, Backcolor As Long, Forecolor As Long)
If IsNull(Variable) Then
Backcolor = vbRed
Forecolor = vbWhite
Else
Backcolor = vbWhite
Forecolor = vbBlack
End If
End Function
Private sub dropdown1_afterupdate()
ChangeColorDropDown me.dropdown1, me.dropdown1.backcolor, me.dropdown1.forecolor
end sub
The colors are however not modified. What do I do wrong?
Many thanks
Ben
How can I modify textfield.backcolor via a function?
I use
Public Function ChangeColorDropDown(Variable As Variant, Backcolor As Long, Forecolor As Long)
If IsNull(Variable) Then
Backcolor = vbRed
Forecolor = vbWhite
Else
Backcolor = vbWhite
Forecolor = vbBlack
End If
End Function
Private sub dropdown1_afterupdate()
ChangeColorDropDown me.dropdown1, me.dropdown1.backcolor, me.dropdown1.forecolor
end sub
The colors are however not modified. What do I do wrong?
Many thanks
Ben