CODEWITHSUNDEEP
ms-access
user745778
user745778

Reputation: 97

List Box enable/disable one column

Access 2007: Is it possible to enable/disable one column in a List Box on a form. For example: Say you have 2 columns A,B - If Me.A = title Then Me.B.Enabled = True Else Me.B.Enabled = False.

If so, where would it go? On Got Focus, On Click??

Thanks

Upvotes: 0

Views: 1024

Answers (1)

chip
chip

Reputation: 2270

I'm not sure what you mean by disable, but you can hide a column by adjusting the ColumnWidth.

So if you wanted to hide column2:

Me.MyListBox.ColumnWidths = (1 in;0;1 in)

And to hide column1:

Me.MyListBox.ColumnWidths = (0;1 in;1 in)

Upvotes: 1

Related Questions