I have a multi-column combobox fed by a query. The combobox populates several text boxes in a userform when a choice is made. According to the data stored in the underlying table, some of these text boxes may display nothing when I scroll through the records.
I would like the text boxes to have one background color when they display data and another when they do not, but the function IsNull is useless, because no text box seems to be null even if it displays no data and there is no data in the corresponding field of the underlying table. What function, if any, can I put in place of IsNull in the following code to highlight textboxes showing data? I am a newby to Access. Any help much appreciated.
Code:
If IsNull(TextBoxName) = True Then
Code:
TextBoxName.BackColor = vbWhite
Else
TextBoxName.BackColor = vbRed
End If