Combo on form in Datasheet view

[ChrisK]

I have a form that I display in Datasheet view and one of the fields is a
combo box with two columns - the first is the bound column with the
autonumber field and the second column has the descriptor.

When I create a combo on a form to be displayed on a form in Form View, I
have 2 columns and set the widths to 0; 1" to hide the bound column. If I
try and use this with the Datasheet view, the drop down doesn't work properly.

Is there a trick I'm missing here?

 

[ssmookherji]

I have a form that I display in Datasheet view and one of the fields is a
combo box with two columns - the first is the bound column with the
autonumber field and the second column has the descriptor.

When I create a combo on a form to be displayed on a form in Form View, I
have 2 columns and set the widths to 0; 1" to hide the bound column.  If I
try and use this with the Datasheet view, the drop down doesn't work properly.

Is there a trick I'm missing here?

hi,
you need to take all the fields nessary in the column and also in the
data field ... once you do that then select the field and mark other
as 0"... it will work fine...
shanki
(e-mail address removed)

 

[ChrisK]

Thanks for the fast response but I'm not sure what you're telling me to do
here.

The combo column is one field in the table but there are two values - the ID
value (which I want to be hidden) and the text value that I want to display.

Where do I mark "other as 0"

Thanks in advance...!

 

[ChrisK]

Anyone got an idea on how I can hide this column in the datasheet view?

CK