Hello again,
I have been searching the forums and it appears that I want to do something that is not often attempted or thought of.
I have a single field returned by an SQL query with up to 15 text items. I would like to have these items displayed from left to right and then descending with perhaps 4 or 5 to a row.
It appears that the ColumnCount property is only for when more than one field is returned and in fact this is the way I normally use it.
My problem is that I simple do not have enough real estate on the form to list these items vertically. Well my client is not interested in that either!
The only work-around I have come up seems like a pain in the rear. That would be to re-format the table(s) into many columns, use the ColumnCount property and then figure out how to trap whichever text in the list the user clicks on. (Like 2nd row, 4th column).
Any advice will be appreciated.
Regards, Sorrells
I have been searching the forums and it appears that I want to do something that is not often attempted or thought of.
I have a single field returned by an SQL query with up to 15 text items. I would like to have these items displayed from left to right and then descending with perhaps 4 or 5 to a row.
It appears that the ColumnCount property is only for when more than one field is returned and in fact this is the way I normally use it.
My problem is that I simple do not have enough real estate on the form to list these items vertically. Well my client is not interested in that either!
The only work-around I have come up seems like a pain in the rear. That would be to re-format the table(s) into many columns, use the ColumnCount property and then figure out how to trap whichever text in the list the user clicks on. (Like 2nd row, 4th column).
Any advice will be appreciated.
Regards, Sorrells
