Hi Guys,
I have a subform that will increase in width when the number of records reaches 8. When it gets wider the scrollbar also appears.
This problem is that I don't actually need it to get wider until the record count is 9, but the scrollbar appears at 8. If I change the VBA to accommodate the new record size the scrollbar cuts off the last portion of the data.
Does anyone know how to have better control over the scroll bar appearing?
I have a subform that will increase in width when the number of records reaches 8. When it gets wider the scrollbar also appears.
This problem is that I don't actually need it to get wider until the record count is 9, but the scrollbar appears at 8. If I change the VBA to accommodate the new record size the scrollbar cuts off the last portion of the data.
Does anyone know how to have better control over the scroll bar appearing?