Text Field displaying across all tabs of a form

T

Trevor

In Access 2000, I have a form with 5 tabs, pulling data
directly from a table. The form has a number of fields
that I would like replicated across all tabs within the
form. Does anyone know where the control is to change
the behaviour of a text field to show on all tabs (pages)
of a form?

Many thanks, it is driving me nuts!!!
 
A

Allen Browne

The text box should show on all pages if it is sitting directly on the form,
and not on one of the pages of the tab control.

1. In form design view, select the text box.

2. Cut (Ctrl+X).

3. Select the form Detail section (gray bar reading "Detail").

4. Paste (Ctrl+V).

5. Move the control to where you want it.
 
A

Albert D. Kallal

You simply can place the text box over and over on the form as many times as
you need.

So, it is not that there is some special "control here. (You seem to have
difficulty understanding the difference between a field in a table, and a
text box on a form, else you would not be asking your question)..

As a general rule, a text box on a form is simply a text control, and DOES
NOT have to have the same name as the field name of the table. In fact, many
developers name the text box different on purpose as to no confuse this
issue.

So, if you Need the persons lastName to display on each tab, simply place a
text box. You might give the first text box the name of LastName1, and then
LastName2 etc. The data source setting of the text box control is where you
make the CONNECTION to the actual field from the underlying table.

So, all of those 5 text boxes can point to the same field name...

And, often, a good solution is to place the common fields "above" the tab
control..so you only need the fields to be placed once on the form, as
opposed to placing a text box contorl on each tab that you have.
 
G

Guest

Alan, Good answer, it worked perfectly and I now
understand a lot more about the structure of Access.

Many thanks, Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form with tabs 1
Form Button appearing on all tabs 1
Form with tabs 3
Error 3048 and Form tabs 4
Linking Tabs 3
Tab Controls Disappear from sight in Form View 17
Tabbing within Form problem 1
Tabs in Forms 2

Top