Access 2013 bugs?

[Clepto]

I run Microsoft Office 365 Professional with Access 2013. Are there any bugs in this version of Access?
I have a problem with a Combo Box with 5 columns. The first is ID and is set at 0cm. The other four are set a various widths, however, only the first visible column appears. If I convert to a List Box, all is well; the problem only occurs in a Combo Box. Also when debugging VBA code, the F8 Step Through feature does not work. It works if I use a break point, but not if a put the cursor in the code and press F8 or select it from the Debug Menu, even though it is lit up as available.

 

[Ranman256]

Did you assign the column count? Col widths are set AND column count must be set to see them all.

 

[gemma-the-husky]

you are seeing the normal behaviour of a combo box

(and you need a control width big enough to accommodate the total width of the individual columns for the drop down, but I don't think this is the issue.)

After you close the drop-down of a combo box, you only see the first non-zero width column, which IS different to what happens with a list box.

Therefore if you want to see more detail in the actual display, you need to redesign the query, and the combo box needs to feature an effectively hidden "display" column

eg. for a control for a person's name

query: recordid, surname+fornames, surname, forenames
column widths, 0, 0.01, 3.2
control width 5

now the drop down shows effectively just the surname and forename because the second column is not wide enough to become visisble

but the closed combo box shows both the surname AND forenames, because it actually IS the first non-zero width column, and you whole value irrespective of the column width

the VALUE of the combo box is generally the first column, in this case the recordid, although you can nominate a different column.

hope that makes sense