ADO connectionstring

Does anyone know how I can get around having to set the ConnectionString at design time for an ADO control?
My application can use different Access databases and I prompt the user to select the correct database.
In the load section of the form I programmatically set the connection string. However, ADO tries to establish the connection to whatever is in the connection string at design time before the Load code is executed.

I've gotten around that by deleting the connection string property of the ADO data control at design time. In the form_load event, I set the connection string and all is good