Get Displayed Text of a ComboBox

[David C. Holley]

I've been playing with programically getting the text value of a ComboBox,
but I keep getting an error message that the control has to have the focus
in order to reference the .Text property. If I explicity set the focus, I'm
able to get the value without any problems.

Is this normal?

 

[Rick Brandt]

I've been playing with programically getting the text value of a ComboBox,
but I keep getting an error message that the control has to have the focus
in order to reference the .Text property. If I explicity set the focus,
I'm able to get the value without any problems.

Is this normal?

For Access yes. If you know the ordinal position of the column being
displayed you can use...

Me.ComboBoxName.Column(n)

....where n is the zero-based position of the column you want.