Hi kevin.

>> Does anyone know why there is a limit in the RecordSource property, I have filled one with a large SELECT statement only to find out it had chopped the last 10 or so characters off the end!!

Any ideas on why there is a limitation anyone? <<

In the property sheet, I think it is probably 254 characters. But you can get around that by constructing a cursor in the form's load method and binding your grid to that instead of a sql statement. Or create a view and bind it to that instead.

Marcia