Add Column (existing field) in Form View

[HandSam]

I have a form whose fields are specified by the user. Sometimes, they need to add a new column. I am able to do this in vba using alter table so that is not the problem. The problem is making this column appear on the form without going to design view. Is it possible for the system to auto show the column on the form without the user going to design view?

 

[arnelgp]

drag as many unbound textbox on your form and initially (on form's Open event) set its HiddenColumn property to True.
Now on the form's load event set which column to make visible, set the Caption of the Label associated with the column. set the columns Controlsource property to the fieldname in your table.

 

[HandSam]

Thanks arnelg, I will try what you said, and I will repost when successful. Many Thanks