ListBox.Column(n)

[H. Martins]

Hi,

Me.lstbxListBox.Column(6)

Is there a way to replace the column index by the column field name?

Thanks
H. Martins

 

[Beetle]

No.

Why would you need to?

 

[H. Martins]

Sean,

Well, it was just a thought.

Sometimes I have to insert (or delete) a new column in a listbox and I
have to change the column index of the function.

The function can be located in the same form, but sometimes is in
other report and I have to search for it.

No big problem, I was just exploring ...

Thanks
H. Martins

 

[Ken Snell \(MVP\)]

Well, yes, it's possible to do in VBA code. Are you comfortable with VBA?
Post back and we can show you how to do this.