>I'm using a listbox on a form, and the data type is a SQL statement. When I put the statement into the properties section of the Property box, it seems to get truncated...how can I prevent this from happening?

To get around the problem you can set RowSource property in the init of the ListBox.