I have a combo box that displays numbers and a name which you click on the drop down, however when you select one the box only displays the number can I have the combo box display the number and name of the one selected. Cheers Rachel
My Column count is set to 3 and I have the sql in the row source:
SELECT tblCourseProvider.CPID, Format([CPNO],"000") AS CPNO1, tblCourseProvider.NameLong
FROM tblCourseProvider;
The 1st column width is set to 0cm; then the other two are visible to the user however once you select a value only the 1st value displays in combo box ie:-
If you select this:-
000 Centre name
The combo box would display 000 only not the centre name as well. Any idea ? Thanks Rachel.
what have you set as the control source of the box?
how's about explicitly setting the width of the other 2 columns?
are you doing anything in the event procedure of the combobox?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.