By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,256 Members | 1,700 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,256 IT Pros & Developers. It's quick & easy.

For combo specialists

P: n/a
I have a combo box with the following rowsource

"SELECT UnitCode, UnitDescFR, UnitDescEN FROM tblUnit WITH OWNERACCESS
OPTION;"

By default the columnwidths are

"0;2880;0" so only the second column show (French description).

With a subroutine, I change the columnwidths to get either the second or
third column, depending of a variable on the form_load event so it can
"0;0;2880" to show the English description. In debugging at the end of
loading, the columnwidths are OK being "0;0;2880".

There is no recordsource since it is for chosing parameters of reports.
Bound Column is 1.

If I am in English mode, what I get is weird. The second column shows, but
when I open the combo box, but it shows the content of the third column!
Only the third column should show even if I do not open the combobox.

I use this sub often and it is the only occasion that I have this issue. I
am puzzled. Any idea? TIA.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Every time you change the column widths you have to requery the ComboBox.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Saintor wrote:
I have a combo box with the following rowsource

"SELECT UnitCode, UnitDescFR, UnitDescEN FROM tblUnit WITH OWNERACCESS
OPTION;"

By default the columnwidths are

"0;2880;0" so only the second column show (French description).

With a subroutine, I change the columnwidths to get either the second or
third column, depending of a variable on the form_load event so it can
"0;0;2880" to show the English description. In debugging at the end of
loading, the columnwidths are OK being "0;0;2880".

There is no recordsource since it is for chosing parameters of reports.
Bound Column is 1.

If I am in English mode, what I get is weird. The second column shows, but
when I open the combo box, but it shows the content of the third column!
Only the third column should show even if I do not open the combobox.

I use this sub often and it is the only occasion that I have this issue. I
am puzzled. Any idea? TIA.


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.