Autpopulating a form stops after column(6)

[melvinlphillips]

Hi everyone. HELP! I'm using a combo box to pull data from a table to auto populate the fields on my form. But for some reason, it stops inserting the data after city (column(6) and I can't figure out what's going on. When I run the query the data is there, if I change the order of the columns, the data shows. Here's the code:

VB CODE:

Me.txtadjusterfname.Value = Me.cboAdjusterlkp.Column(0)
Me.txtadjusterlname.Value = Me.cboAdjusterlkp.Column(1)
Me.txtadjustertitle.Value = Me.cboAdjusterlkp.Column(2)
Me.txtadjustertype.Value = Me.cboAdjusterlkp.Column(3)
Me.txtadjustercompany.Value = Me.cboAdjusterlkp.Column(4)
Me.txtadjusteraddress.Value = Me.cboAdjusterlkp.Column(5)
Me.txtadjustercity.Value = Me.cboAdjusterlkp.Column(6)
Me.txtadjusterstate.Value = Me.cboAdjusterlkp.Column(7)

 

[missinglinq]

Assuming that the Control name is spelled correctly, my guess would be that you've bumped into one of Access' limits. I don't recall, right off-hand, how many characters a single line in a Combobox can have, but there is a limit, and I expect, given that you have 8 Fields, that you've surpassed it.

Linq ;0)>