Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Location
    New York
    Posts
    4

    Smile Unanswered: ListBox Limitations

    Hello everyone . . . .

    Does anyone know the size limitation of Rows & Columns in a ListBox?

    Does anyone know the limitation of data returned from a query in the RowSource?

    I have a situation where the number of rows increases as I decrease the nimber of columns.

    Deleted & reconstructed the ListBox several times with no change in results.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465

    Re: ListBox Limitations

    Originally posted by TheAceMan1
    Hello everyone . . . .

    Does anyone know the size limitation of Rows & Columns in a ListBox?

    Does anyone know the limitation of data returned from a query in the RowSource?

    I have a situation where the number of rows increases as I decrease the nimber of columns.

    Deleted & reconstructed the ListBox several times with no change in results.
    Can you clarify the problem.
    Saludos
    Norberto

  3. #3
    Join Date
    Mar 2004
    Location
    New York
    Posts
    4

    Re: ListBox Limitations

    Originally posted by Norberto
    Can you clarify the problem.
    How are ya Norberto . . . . . .Thanks for the reply!

    Have a ListBox on a form. Nothing else is on the form. The ListBox RowSource is set to Query (there are quite a few columns in the query), and the ListBox is unbound. The query is simply a mirror of a table and its only real purpose is sorting. There is no criteria!

    When I open the form with all the columns in the query, only 16 rows show in the listbox(so scrollbar). However, if I run the query, it returns 37 records! With that I started testing to see if I could find what happen to the missing rows.

    Removing the columns one by one from the query, closing and reopening the form, I found that as I removed columns, row count would increase, and vice versa.

    As an Access DB programmer for many years myself and using a great many ListBoxes in that time, I've never seen or noticed this type of behavior. I don't know what it is yet, but, there appears to be some kind of limit as to the Data Load returned by the queries recordset.

    I hope this more informative, and thanks again for your reply.

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465

    Re: ListBox Limitations

    Originally posted by TheAceMan1
    How are ya Norberto . . . . . .Thanks for the reply!

    Have a ListBox on a form. Nothing else is on the form. The ListBox RowSource is set to Query (there are quite a few columns in the query), and the ListBox is unbound. The query is simply a mirror of a table and its only real purpose is sorting. There is no criteria!

    When I open the form with all the columns in the query, only 16 rows show in the listbox(so scrollbar). However, if I run the query, it returns 37 records! With that I started testing to see if I could find what happen to the missing rows.

    Removing the columns one by one from the query, closing and reopening the form, I found that as I removed columns, row count would increase, and vice versa.

    As an Access DB programmer for many years myself and using a great many ListBoxes in that time, I've never seen or noticed this type of behavior. I don't know what it is yet, but, there appears to be some kind of limit as to the Data Load returned by the queries recordset.

    I hope this more informative, and thanks again for your reply.
    Really that is new......
    Wy don't use a wizard for query my be that work.....!
    Saludos
    Norberto

  5. #5
    Join Date
    Mar 2004
    Location
    Berlin, Germany
    Posts
    107

    Re: ListBox Limitations

    Originally posted by TheAceMan1
    Hello everyone . . . .

    Does anyone know the size limitation of Rows & Columns in a ListBox?

    Does anyone know the limitation of data returned from a query in the RowSource?

    I have a situation where the number of rows increases as I decrease the nimber of columns.

    Deleted & reconstructed the ListBox several times with no change in results.
    i guess U had a look at the Column Count Property of the list box?

    Cheers
    Bachatero

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •