MsgBox AfterUpdate

[Guest]

I am trying to display a message when Me!cboHolder.Column(6) has text stored
in it. If there is no text in that column for that record I don't wont the
box to popup. I tried, but it doesn't equal exactly "True"! Here is the code:

If Me!cboHolder.Column = True Then MsgBox " text"

I also tried useing greater than true but the box pops up for all records
even if there is no dad in the field. Could someone point me in the right
direction? All I want is a box that populates when data is in the column(6)
field, and no box when there is no data! Thanks ahead of time!

 

[Guest]

Hi, James.
I think...

If IsNull(Me!cboHolder.Column(6)) Then
...do nothing
Else
...populate combo box
End If

....ought to do it.

HTH
Sprinks

 

[Ken Snell [MVP]]

If Len(Me.cobHolder.Column(6) & "") > 0 Then MsgBox "text"

 

[Guest]

Thank you, that worked! I will look up the Len function to see how it works.