CODEWITHSUNDEEP
vbams-accesscombobox
Spring
Spring

Reputation: 900

Assign value to multiple column combo box in VBA access

I set a combo box column count=2 and the combo box column width="0;1" i set one column width=0 because i need to hide this column. when i assign a value to the combo box for example combo Box="12" but this value is in the first column.So i want to assign it to the second column but how?

Upvotes: 0

Views: 2056

Answers (3)

Rdster
Rdster

Reputation: 1872

If you are hiding the first column anyway...why not just get rid of it to begin with. Then you'll have one column and that combo box will bound to that one by default.

Upvotes: 0

Sham Yemul
Sham Yemul

Reputation: 463

It is the boundcolumn property that decides what will be stored in the value property and corresponding column number. Make sure you have boundcolumn=2 for above your requirement of 0 width first column, assign combo value to second column

Upvotes: 0

Gustav
Gustav

Reputation: 55806

Set its property at Data, BoundColumn to: 2

Or reverse the columns and hide the last column.

Upvotes: 2

Related Questions