I can't find the field list tool bar in Access 2003.

[Guest]

I added a field to a table and Query but the new field doesn't show up in my
field list, so I am trying to use the field list tool bar refresh button but
don't see it anywhere.

 

[Ken Snell \(MVP\)]

In which object's design view are you wanting to "find" this field list
button?

 

[Guest]

I am in form design view.

In which object's design view are you wanting to "find" this field list
button?

 

[Van T. Dinh]

You can use either tthe Menu command View / Field List or the Field List
icon in the Form Design Toolbar. The icon looks like a list (what else)
just left of the ToolBox icon.

If your Form is unbound, the Menu command and the icon will be disabled.

 

[Guest]

Hi Van,

Thank you for the reply and I understand what you are saying. But when you
look up help for the topic "FIELD LIST" within Access 2003, It talks about
the refresh button icon on the FIELD LIST TOOLBAR and shows a picture of this
icon, that is what I am looking for and I don't see it.

 

[Brendan Reynolds]

What's the title of that help topic?

 

[Brendan Reynolds]

OK, disregard my previous post. I found it. It's 'Refresh the field list of
a data access page'. The key words here are 'data access page'. From your
previous post, you are designing a form, not a data access page, so this
help topic does not apply to your situation.

 

[Guest]

Thank you Brendan,

I was not understanding the field toolbar correctly. Can you tell me why
after I added a field to a table and then to the Query that is used to gather
the data for my form, that I don't see that new field in the field list.
Please tell me that I don't need to delete the form and start the form over.

 

[Brendan Reynolds]

Normally the field is visible once it has been added to the query or select
statement, so I'm not sure why that is not happening for you. A couple of
things you can try ...

Double-check that the field is included in the SELECT clause of the query.
If you're looking at the query in design view rather than in SQL view, make
sure that the check box in the 'Show' row is checked for that field.

If the form was open when you made the changes to the table and query, try
closing and re-opening the form.

 

[Gina Whipp]

The field list refresh button is only available on Data Access Pages, not on
regular forms.

 

[Guest]

Hi Brendan,
The field shows up on my field list now. Thank you for your help.