Access 2000 tab control

[Guest]

I have a form that is getting too full and wish to change to a tabbed type
form. If I copy the controls from the form to the tab control the underlying
code does not copy. Is there a way to do this?

 

[Rick Brandt]

I have a form that is getting too full and wish to change to a tabbed
type form. If I copy the controls from the form to the tab control
the underlying code does not copy. Is there a way to do this?

The "code" is still there. What you lose is the entry in the event property box
[Event Procedure] which makes the code run. You need to manually put that back
for all controls that require it.

I have never tried this, but I have seen postings that suggest that if you go to
the code window and cut ALL the code to the clipboard and then re-paste it that
the Access will insert all of the [Event Procedure] entries for you. Worth
trying.

 

[Douglas J. Steele]

I have a form that is getting too full and wish to change to a tabbed
type form. If I copy the controls from the form to the tab control
the underlying code does not copy. Is there a way to do this?

The "code" is still there. What you lose is the entry in the event
property box [Event Procedure] which makes the code run. You need to
manually put that back for all controls that require it.

Or you can use the code in my March, 2004 "Access Answers" column in
Pinnacle Publication's "Smart Access".

You can download the code (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Guest]

Thankyou both for your help