Rod,
Thank you so much for your insight!
You have made my day!!!
I did exactly what you told me to do.
The module ended up looking like this:
[Private Sub Sort_AfterUpDate()
If (Sort = 2) Then
lstForm.RowSource = "qry_FormsByNumber"
Me.lstForm.ColumnWidths =...
I have a list box on a form. There are 2 options: Name and Number. Name is the default. When I select Name I get a two column return and that works great. I select Number and that works great.. except, I need the ColumnWidths of the Number option to be reversed.
Example: Name = 4.0;0.75;0...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.