Getting label (not value) from a dropdownlist?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerome - 18 Aug 2005 09:51 GMT

Hi,

I've got a dropdownlist based on a query. The list contains two fields:
the (invisible) ID and the corresponding text/label.

I can get the ID by referring to me.dropdownlist1.value , but how can I
get the label??

Thanks a lot,

Jerome

Reply to this Message

Baz - 18 Aug 2005 10:28 GMT

> Hi,
>
[quoted text clipped - 7 lines]
>
> Jerome

Me.dropdownlist1.column(1)

Reply to this Message

Graham Mandeno - 18 Aug 2005 10:29 GMT

Hi Jerome

It will be Me.Dropdownlist1.Column(1)

The Column property starts numbering from 0, so the nth column is
.Column(n-1)

Signature

Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

> Hi,
>
[quoted text clipped - 7 lines]
>
> Jerome

Reply to this Message