Add to a form field list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you add to a form field list once the form has been created? I added
another field to the query, and I'd like to add this field to my form, but I
didn't select the additional field when I created the form.

Thank you
 
Hi.
Can you add to a form field list once the form has been created?
Click to expand...

Yes. The form field list is merely a list of the fields available in the
form's "Record Source" Property. Place your form in Design View, then select
the "Field List" button on the toolbar or use the View menu to select the
"Field List." When the "Field List" appears, scroll down to your desired
field, select the field and drag it to your form wherever you want, then save
the form.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts, so that all
may benefit by filtering on "Answered questions" and quickly finding the
right answers to similar questions. Remember that the best answers are often
given to those who have a history of rewarding the contributors who have
taken the time to answer questions correctly.
 
Absolutely. Just find the new field in the field list and drag it on to your
form. You'll have to manually rearrange the existing fields to make room for
the new field. Be sure to take a look at Format-->Align to help you get the
new control positioned correctly.
 
M,
If your form is based against a table, and you added a new field to your
table, it will be available to place on your form.
If you used a query, go into that query and make sure the new field has
been added to the recordset.

Given that... in design mode for the form, use View/FieldList, and your
new field should be there.
hth
Al Camp
 
Back
Top