Group:  Microsoft Access ยป microsoft.public.access.formscoding
Thread: ListBox.Column(n)

Geek News

ListBox.Column(n)
"H. Martins" <HJRMartins[ at ]gmail.com> 12/17/2008 3:25:55 PM
Hi,

Me.lstbxListBox.Column(6)

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

Thanks
H. Martins
RE: ListBox.Column(n)
Beetle 12/17/2008 3:42:11 PM
No.

Why would you need to?
--
_________

Sean Bailey


"H. Martins" wrote:

[Quoted Text]
> Hi,
>
> Me.lstbxListBox.Column(6)
>
> Is there a way to replace the column index by the column field name?
>
> Thanks
> H. Martins
>
Re: ListBox.Column(n)
"H. Martins" <HJRMartins[ at ]gmail.com> 12/18/2008 11:33:09 AM
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
Re: ListBox.Column(n)
"Ken Snell \(MVP\)" <kthsneisllis9[ at ]ncoomcastt.renaetl> 12/20/2008 3:12:21 PM
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.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


"H. Martins" <HJRMartins[ at ]gmail.com> wrote in message
news:f249bf37-ed2f-4ad4-8f1a-4b01b6e5dd16[ at ]r10g2000prf.googlegroups.com...
[Quoted Text]
> 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


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net