Run Time Text Box

[RandyC]

I have created a button that created a text field in a table and now I would like for the field to show up on a form(as a text box). This is so a user can add fields to the database from the input screen. I would like the text box to automatically show up while the user is entering data on the form without going into design mode.

 

[jimbrooking]

Hi Randy,

Welcome to the Access forums.

Not sure I understand your question, but will try to answer anyway. (Am I a consultant, or what? )

In the Design View for a form, click the "Field List" icon that's just to the right of the "Insert Hyperlink" button in the Form Design toolbar. This lets you see the fields in the record source for the form. Drag 'n' drop any field name into the form and it will appear as a labeled text box tied to the field in your table or query.

If you have no idea what I'm talking about, look at the Forms objects in the database window and click "Create Form Using Wizard".

Cheers,
Jim