Will DLookup do me any good?

[RachelBedi]

I think I figured it out - this is a form in datasheet view - I changed it to Continuous forms and the same result the field is not hidden but in single form view the field is hidden. Is there a datasheet version to hide the column based on a field value?

[RachelBedi]

GOT IT!!! Thank you SO much for your help Orange - can't tell you how appreciative I am of you being so patient :-D

Private Sub Form_Current()
Me.Text41 = DLookup("RoleName", "qryRole", "RoleName")
If Me.Text41.Value = DLookup("RoleName", "qryRole") = "Dividends/Commissions" Then
Me.[Bank Modified Date].ColumnHidden = False
Else
Me.[Bank Modified Date].ColumnHidden = True
End If
End Sub

[orange]

Private Sub Form_Current()
Me.Text41 = DLookup("RoleName", "qryRole", "RoleName")
f Me.Text41.Value = DLookup("RoleName", "qryRole") = "Dividends/Commissions" Then
Me.[Bank Modified Date].ColumnHidden = False
Else
Me.[Bank Modified Date].ColumnHidden = True
End If
End Sub

I think this should work
Private Sub Form_Current()
=
If DLookup("RoleName", "qryRole") = "Dividends/Commissions" Then
Me.[Bank Modified Date].ColumnHidden = False
Else
Me.[Bank Modified Date].ColumnHidden = True
End If
End Sub