Help with Tab Control

E

erick-flores

hello all

I know about most of the option in Access, but I have never used the
Tab Control control. I have a table with 3 fields. Comments1, Comments2
and Comments3. What I want is create a Tab Control and put each field
in one tab and be able to write the comments on each tab. When I finish
writing the comments on the field/tab Comments1 I can then click on the
2nd tab and so on. How do I do this?

Thanks in advance
 
M

missinglinq via AccessMonster.com

First thing to remember is that the Tabbed Pages are all part of a single
form; think of it as a really long form turned on its side. Because it is all
one form, all referrencing to any contol on it is done in the same manner as
if they were all on one single screen. No fancy referrence tap-dancing like
you have to do if you're using subforms. Creat a form in Design View. Goto
the toolbox and click on the Tabbed Control icon; it actually looks like
several file folders. Place it on your form and size it like you want. Click
on the tabbed control to select it. Goto Insert and click on Tabbed Control
Page. A third tabbed page will be added.

This is the really important part: when yuo go to add a control to a tabbed
page, you must first click to select one of the pages, then add the control.
Otherwise, the control will be added to the form itself, and will show thru
on all tabbed pages!

Once you have the form's Control Source (your table or a query) set up, you
simple add your text boxes, etc.

Good Luck!
 
J

John Vinson

hello all

I know about most of the option in Access, but I have never used the
Tab Control control. I have a table with 3 fields. Comments1, Comments2
and Comments3.
Click to expand...

Then your table's design is questionable! What if you ever need a
fourth comment? If you're using the Memo datatype for these comments,
you can type 65536 characters in each - do you really need 196608
characters of comment? Does the table have any OTHER fields - such as
a foreign key?
What I want is create a Tab Control and put each field
in one tab and be able to write the comments on each tab. When I finish
writing the comments on the field/tab Comments1 I can then click on the
2nd tab and so on. How do I do this?
Click to expand...

Simply create a Tab Control using the toolbox wizard. Tell it you want
three tabs; you'll get the opportunity to label each of them. Put a
Textbox control on each tab (making it big enough for the whole
comment); to do so, be sure you have selected the tab page when you
insert the control from the toolbox.

John W. Vinson[MVP]
 
R

Rick Brandt

erick-flores said:
hello all

I know about most of the option in Access, but I have never used the
Tab Control control. I have a table with 3 fields. Comments1,
Comments2 and Comments3. What I want is create a Tab Control and put
each field in one tab and be able to write the comments on each tab.
When I finish writing the comments on the field/tab Comments1 I can
then click on the 2nd tab and so on. How do I do this?

Thanks in advance
Click to expand...

Bind the form to your table and then add a TabControl to it. Place a TextBox in
each TabPage with each one bound to a memo field in the table. That'sll there
is to it.

If you already have three TextBoxes on your form just cut each one to the
ClipBoard, select the desired TabPage, then Paste.
 
Top