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