Access 2007--Alter table using vb.

[bcofie]

Prive Sub AddColumn_Click()


CurrentDB.Execute("ALTER TABLE ADD COLUMN NewField Text(30);")

This above works but I want to replace NewField with Me.TextBox1.Value so that user can type in a name in textbox on form and add as a field.
Also will like to replace Text(30) with Me.Cbo.SelectedValue.

I know letting users add fields is not great idea but until I manage to talk them out of it...........

Thanks!!!

[June7]

Concatenate the variables:

CurrentDB.Execute "ALTER TABLE ADD COLUMN [" & Me.TextBox1 & "] Text(" & Me.Cbo & ");"

If this is required to maintain database, sounds like data structure is wrong. How does this impact design of forms and reports?