Technologies:

VB6/ADO2.1/SQL Server7

I am writing an application in which the user selects table, then clicks a
command button which opens an input form.
The form loads labels, text-boxes/checkboxes based on the table that user
has selected.
It works great - and saved me the time of creating 18 separate forms, one
for each table.

One problem, though, is that I would like to set a textbox's "Multi-line"
property to true if the data  type is SQL Server's "text" (ADO's
adLongVarChar). It turns out that the "Multi-line" property is read-only at
run-time.

Does anyone out there know (or can suggest) a work-around to this
limitation. The only thing I can think of is to place several "multi-line"
text boxes on the form at design time, and make a given text box visible in
response to the field being the "text" data type. I would like to avoid
"exception-based" coding such as this.

Any help very much appreciated.

Larry Calame