mamradzelvy suggestion works in Access 2010. In fact it's really good but gee have I struck a real brick wall trying to figure out what Access is doing.
Is the number of columns in a list box limited to 9 ?
Because the attached only shows 9 columns- ignoring a tenth field in the table called 'Direction'
Wondering if the listbox width may be the problem, I then found the its width would not change
Form width is set in Load event with MoveSize to 25000, but printing this in the debug.window says its 16610
The command
Listbox1.Width= Me.Width in Form Load is ignored and list width debug.prints as 15647. In list properties this is shown as 25.317cm. I don't know how to correlate the two. By the way, which take precedence, properties or code in Form Load ?
So I've been a few hours unsuccessfully trying to figure out
1) Why Form width isn't 25000
2) Why list width isn't changing to Form width as instructed (or any other width in Form Load)
3) Why not all the list columns are showing.
Thanks for any answers.