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

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)