Wortz, Charles
CWortz at tea.state.tx.us
Thu Jul 24 14:10:48 CDT 2003
Susan, Access has limits on character string length. Your strings may be exceeding one of these limits. All Access objects do not have Long Integer, or even Integer, position counters. Some only have a byte length counter. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Susan Geller [mailto:sgeller at cce.umn.edu] Sent: Thursday 2003 Jul 24 14:00 To: dba-SQLServer at databaseadvisors.com Subject: [dba-SQLServer]Listbox truncating stored procedure data I have a listbox whose recordsource is a sproc. The sproc works fine even when run from Access. The listbox has an invisible column that contains a long text string, up to a couple of paragraphs in length. The listbox is only holding the first couple of lines even though the sproc returns the whole thing. I can work around this by getting at the data in another way, but I'm wondering if this is a bug of some kind? Access XP --Susan Susan B. Geller Office of Information Systems College of Continuing Education University of Minnesota 306 Wesbrook Hall 77 Pleasant Street SE Minneapolis, MN 55455 Phone: 612-626-4785 Fax: 612-625-2568