Ken,
The length of the value of a string property when entered on the property sheet is limited to 255 characters.
Also the maximum length of any string constant is 255 characters.
Strings and string property lengths are only limited by available memory.
Have you tried setting the RecordSource property from code?
>I found it by going to the record source and typing 12345678901234567892 etc. Sucker froze at 255!