So I am working in access trying to get different queries to pull specific information when a select case is met.

This is what I have so far

```
Select Case Me.vPipeFlowDirection.Value

    Case "All"
        Me.vPipe_Name.RowSourceType = "Table/Query"
        Me.vPipe_Name.RowSource = "Select * From qryList_V_Profile_PI_AllPipeNames"
        Me.vPipe_Name.ListWidth = 3.5
        Me.vPipe_Name.ColumnCount = 2
        Me.vPipe_Name.ColumnWidths = "3in, 0.5in"

    Case Else
        Me.vPipe_Name.RowSourceType = "Value List"
        Me.vPipe_Name.RowSource = "None"
End Select

```

The issue is that the the List Width is working but its putting a horizontal scroll bar instead of making the drop down box bigger