Right! You get more than one row (result) from your query without the distinct key word. So, you can not associate a bunch of rows to a single text field as is combo/txt box. It's not the length of text but the number of rows which is the problem or why the error msg. You need to rethink what you are after, or add distinct to your select statement or Top 1 to make it work.