Combo Box Default

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

I swear there's a simple way to make the default value of a combo box the
first item in the itemdata list. I can't remember how. Help?
 
Hi Jim,

Easiest is to place this in the Default Value property (cbTypeCode
being the name of the combo box in this example):

=[cbTypeCode].[Column](0,0)

Clifford Bass
 
I think that will only work if the first column is the bound column,
Clifford. If, for instance, the third column was the bound one, I believe
you'd need to use

=[cbTypeCode].[Column](0,2)

Probably better off to use

=[cbTypeCode].ItemData(0)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Clifford Bass said:
Hi Jim,

Easiest is to place this in the Default Value property (cbTypeCode
being the name of the combo box in this example):

=[cbTypeCode].[Column](0,0)

Clifford Bass

JimS said:
I swear there's a simple way to make the default value of a combo box the
first item in the itemdata list. I can't remember how. Help?
Click to expand...
Click to expand...
 
Back
Top