Hi,
I havea listbox that upon form opening has a horizontal scroll bar.
I use additem to add a string that has 26 columns i.e. 26 text strings separated by ';'
It did have a lot more columns. The string, in total, is definetly wider than the list box.
The problem is the scroll bar disappears, any ideas?
Code:
Select Case frmExtras
Case 1
intFieldCount = 57
Me!lstResult.ColumnCount = 26
Me!lstResult.ColumnWidths = "1cm;1cm;1.822cm;1.2cm;4cm;1cm;1cm;1cm;1.6cm;1.6cm;1.6cm;1.6cm;1.6cm;1.6cm;1.6cm;3.6cm;1.6cm;2.2cm;2.1cm;1cm;1cm;1cm;1cm;1cm;1cm;1cm"
Set qdf = myDb.QueryDefs("qryAssetDetails_structure")
strHdg = "Asset;Comp;Asset Code;IPM No;Asset Name;Comp;Make;Cond;LengthPCT;Easting;Northing;Plan;Run Dist; End Dist; Owner;Last Inspection;Bank Side;" & _
"Structure Type;Structure Name;Safety;Scouring;Increase;Capacity;Capacity Constraint;Serial Number;Load Capacity STD Code;Material"