Getting label (not value) from a dropdownlist?

  • Thread starter Thread starter Jerome
  • Start date Start date
J

Jerome

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
 
Jerome said:
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
Click to expand...

Me.dropdownlist1.column(1)
 
Hi Jerome

It will be Me.Dropdownlist1.Column(1)

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