Moving/deleting Tabs in a form

supermorg

New Member
Joined
Mar 9, 2009
Messages
1
Hey everyone,this may seem like a stupid question but i have been trying for a few hours how to figure it out and thought i would turn to this site. Anyways I created a form using the form wizard and am attempting to change the format. I wanted to delete a few of the field names (not the field itself) and i also wanted to move some stuff around but when i try to it deletes both and wont let me move anything but the whole form itself. Thanks to anyone that can help!
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
When you say "tabs", it sounds as though you actually mean field LABELS, those little text boxes to the left of each data field that display the field name and ":" at the end. If that is so, read on. Otherwise, your problem is with something other than "tabs", which only exist in tabbed forms, which cannot be created with a wizard.

Assuming you mean field labels, are you using Access 2007? In Access 2007, forms created with a wizard have all their fields and labels grouped together: deleting or moving one does the same for all. To ungroup, go to Layout mode, right-click on any field on your form and from the pop-up menu select Layout/Remove. This will ungroup your objects so you can move, resize, and selectively delete them.

If you are using something earlier than Access 2007, let me know I'll try to replicate the problem at home tonight (where I have Access 2003).
 
Upvote 0

Forum statistics

Threads
1,196,028
Messages
6,012,956
Members
441,740
Latest member
IammeResources

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top