Hi, I set the Grid.RecordSource to ' ' at the design stage. At runtime, this seems to disable the Grid's binding of the Columns/TextBoxes. In fact at runtime, you must set it to ' ' before changing the SQL statement because otherwise the Grid's settings such as BackColor etc. will be reset to defaults.

Hope that helps.


>I'm not sure how your suggestion would work as if there is a reference to the alias in the column or textbox, wouldn't that cause the same error on initialisation even if the column.controlsource was set to ' '?