empty listbox, A97, SQL Server

  • Thread starter Thread starter david epsom dot com dot au
  • Start date Start date
D

david epsom dot com dot au

I have a list box bound to a query that includes a memo field. The memo
field is not visible. For some data, the list box is unaccountably empty
(no error is reported). If I remove the memo field from the query, the list
box fills correctly. If I run the query alone, the query returns the
correct results. Refreshing all the data in the memo field has no effect.
For other records, the list box fills correctly.

A97 SP2 SR2. SQL Server 2000

Has anyone else ever seen similar behaviour?


(david)
 
Does your Query begin with

table.*
(Show)

If not, try this. By default, to see this value, you have
to scroll up in the table to see it.

Hope this helps.

Tom M
 
Back
Top