>I am trying to use a rather complicated SQL statement as the RowSource in a ComboBox. I right click on Rowsource on the property sheet and select Zoom. Then I type in my statement. I've discovered that I am limited to a certain number of characters before my statement is truncated after hitting enter. I've tried abbreviating as much as possible and still find that I am about 25 characters too long. Is there a way around this?
>
>Thanks.
>Jay

The Property Sheet is limited to (I believe) 254 (255?) characters. You might try setting the property programmatically in the control's Init event.

THIS.RowSource = [my very long SQL statement here]

HTH.