access training onsite uk - Tab control on forms

The UK's most regular instructor-led training courses.
Training information: access training onsite uk · Microsoft access courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Tab control on forms

Sinéad has attended:
Access Intermediate course
Access Advanced course
Access VBA course

by - delegate Sinéad [15 posts] (2007 May 30 Wed, 11:07) Reply

I have added a tab control to a form and want to have to tabs on it with different fields visible when you click between each tab. When I add a tab control and drag fields to the control, they show up on both tabs rather than just one. What am I missing?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: tab control on forms

by - trainer Richard platinum contributer [818 posts] (2007 Jun 1 Fri, 10:00) Reply

Hi
An easy one to miss, I did it many times.

When using a tab control you must drag the fields directly onto the tab field area from the FIELD LIST. You will notice that the tab area highlights when you do this, indicating that it is on the tab section.

Otherwise you are just adding the field to the whole form.

Test it out with a blank form

Regards

Richard

· When Is Microsoft Access Not The Best Choice For Your Business?
· Why consider Access Visual Basic training?
· Reasons to Consider Microsoft Access Training
· Microsoft Access 2007: New Features
· Microsoft Access Training Unleashes the Power of the Pivot Table

Access tip:

Remove spaces in a table

If you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks

View all Access hints and tips