List of fields on a form.
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
List of fields on a form.
This list is available in Access 2003 but i cannot find it in Access 2007.
-
- Administrator
- Posts: 78790
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: List of fields on a form.
In Access 2007/2010 you can - stupidly - display either the field list or the property sheet but not both at the same time. Activate the Design tab of the ribbon and click Add Existing Fields to display the field list.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: List of fields on a form.
Those are the available fields from the source of the form, what i want to see is the list of fields that are currently used on a form.
-
- Administrator
- Posts: 78790
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: List of fields on a form.
The list of "objects" on the form (the form itself, its sections and controls) can be viewed in the dropdown at the top of the Property Sheet:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 287
- Joined: 09 Mar 2010, 23:16
- Location: Canberra Australia
Re: List of fields on a form.
I can't remember Pat. Where is this list in 2003?Pat wrote:This list is available in Access 2003 but i cannot find it in Access 2007.
Regards
John
John
-
- Administrator
- Posts: 78790
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: List of fields on a form.
If Pat means the list of objects, as I suspect, it is on the left hand side of the Formatting (Form/Report) toolbar.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: List of fields on a form.
Thanks Hans, easy when you know where.
Hi John, i see Hans has answered you question.
Hi John, i see Hans has answered you question.
-
- 3StarLounger
- Posts: 287
- Joined: 09 Mar 2010, 23:16
- Location: Canberra Australia
Re: List of fields on a form.
You can add this to the Quick Access Toolbar. You will find it under All Comands...Object
You do not have the required permissions to view the files attached to this post.
Regards
John
John