Gnana,

The values entered on the property sheet are limited in length. You can set the RecordSource inside code in the Init() method. Note that no single string constant can exceed 256 characters. So to get a longer total string you have to add substrings together.

this.RecordSource = "select ......" + ;
   "where..." + ;

>I set the recordsourcetype of a grid control to 4 (SQL statement). And I am trying to set the recordsource property to a select statement (string). But my 'select statement' is long and it is getting truncated to 259 characters. How can I increase the limit on the length of strings. Or any other way of getting around this problem.