Combo Box members not visible

[pstraszynski]

Hi everyone!
I have a combo box with a Row Source Type of Table/Query. The Row Source is the following query:

SELECT [Mer Status].STATUSES_FOR_MERS FROM [Mer Status] ;

Where STATUSES_FOR_MERS is an alphabetic field in table Mer Status

Visible is set to "Yes", and Display When is set to "Always". When I run the form and click on the drop-down arrow, there are no values visible like there should be. I've experimented with colours, making them similar to other Combo Boxes so that's not the problem. Oddly enough, when I just blindly click on the "empty" values list, a legitimate value is selected and appears in the display part of the Combo Box. So that means the query works.

This same Combo Box used to work for the user and now it doesn't. Could this have something to do with a change in the users' PC? I read something about this kind of problem but the writer was using a different version of Access and no solution was given anyway. I'm running Access 2003 (11.8166.8221) SP3. Any help appreciated! Paul in Canada

 

[Starman]

It sounds like you need to fix your columns. In the properties box of the combo box, make sure you set the Column Count property to the number of columns in your combo box. Then make sure your column widths are set to however wide you need them.