Can't change formatting in a form...

Try import ALL objects into a brand new ACCDB ....

mx

from access menu
tools > database utilities > compact and repair database


see if that will take care of the problem.

if not , you might have to recreate your form

Where is "Compact and Repair Database" in access 2007?

Nevermind! I found it. I'll try and let you know.

This may work also:

A **DeCompile** may help here ...

But first, if you have not already:
Open the VBA Editor and from the menu ...Tools>>References ....
If you see any listed as **Missing: <reference name>, including the asterisks and the word Missing, the
you need to fix that first.

Then, follow this procedure:

****
0) **Backup your MDB BEFORE running this procedure**
****
1) Compact and Repair the MDB, as follows:
Hold down the Shift key and open the MDB, then from the menu >>Tools>>Database Utilities>>Compact and Repair ...
Close the mdb after the Compact & Repair.
2) Execute the Decompile (See example syntax below) >> after which, your database will reopen.
3) Close the mdb
4) Open the mdb and do a Compact and Repair (#1 above).
5) Close the mdb.
6) Open the mdb:
    a) Right click over a 'blank' area of the database window (container) and select Visual Basic Editor. A new window will open with the title 'Microsoft Visual Basic' ... followed by then name of your MDB.
    b) From the VBA Editor Menu at the top of the window:
       >>Debug>>Compile
        Note ... after the word Compile ...you will see the name of your 'Project' - just an fyi.

7) Close the mdb
8) Compact and Repair one more time.

*** Executing the DeCompile **EXAMPLE**:
Here is an **example** of the command line syntax  (be SURE to adjust your path and file name accordingly) before executing the decompile:

Run this from Start>>Run, enter the following command line - **all on one line** - it may appear like two lines here in the post:
Also, the double quotes are required.

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile "C:\Access2003Clients\YourMdbNameHERE.mdb"

For more detail on the Decompile subject ... visit the Master on the subject (and other great stuff) Michael Kaplan:

http://www.trigeminal.com/usenet/usenet004.asp?1033

mx

I tried to decompile, changing the appropriate names but it wouldn't work. I looked where the command line indicated the compile switch might be and it wasn't there, allthough I may be looking for something that's not supposed to be there or is hidden (except I have all my hidden things showing). Is this for Access 2007 (I noticed the "Access2003Clients" reference in the CL)? If not, would you be able to provide guidance for Access 2007?

Decompile does in fact work in A2007.   You have to get the correct paths to the Access executable.

"I looked where the command line indicated the compile switch might be and it wasn't there"
Not quite sure what you mean ?

mx

I guess I meant that I thought "decompile" was going to be in the folder the command line drilled down to, but I realize now it's meant to force the decompile to happen TO what's in the command line.

So I managed to do this, and it appears to be doing it, but my DB is on a server and I don't think it's affected by what I'm doing. Is it possible to decompile from a server or do I have to temporarily copy the DB to my hard drive?

Well ... yes it *can* be done on the server from your workstation, but ... definitely copy to your local work station ... Decompile, then copy back.

mx

It's not letting me do it. I'm using the following:

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile "C:\Access2007Clients\RTS Database.mdb"

Close to what you had above but with my own DB name. What next?

If this is A2007 then shouldn't MDB >>> ACCDB ?

What IS it doing ? Error ?

mx

Yes, see attachment.
Access-error.gif

OK, figured out (part of) the problem. My folder is Office12, but when it runs it says it can't find the file. I've checked and it's the correct path on the C drive. What am I missing?

I think I must be getting tired. Forgot the underscore in the DB name. Will try again and let you know.

Next issue:

Can't get here: a) Right click over a 'blank' area of the database window (container) and select Visual Basic Editor. A new window will open with the title 'Microsoft Visual Basic' ... followed by then name of your MDB. Do I need to open a module or is there another way to get where I need to be?

Access-error-1.gif

I'm not on my A2007 machine at the moment.  You need to get into the VBA editor.  You could start a new module ... do the Compile ... and not save the new module.

mx

When I get to step 6.a., is opening Visual Basic from the "Database Tools" menu the same as going into "Visual Basic Editor"? and if so, in which part of the window do I perform the subsequent instructions? (See attachment)
Access-error-2.gif

OK. I tried creating a new form and going into the Event property and debugging from the debug menu and completed (I think) the rest of the instructions and it is still not letting me save changes.

Can you:

1) Compact & Repair (*** to shrink the size),

2) Zip up the MDB (*** to further shrink the size)

3) Attach the file for upload here (using the 'Attach File function below) ... removing any sensitive data of course.

4**** And please give a clear explanation of exactly how to reproduce the problem or what you are trying to do.

NOTE:  If you have an A2007 ACCDB, please convert to A2003 MDB.
mx

OMG! I'm not why it worked, but I went back to the original database (that I copied to my HD) and did a VB Editor debug in one of the forms I was having trouble with and it looks like it worked! I made a change and it let me save! I'll try on the others with issues (if that didn't do the universal trick) and let you know.

:-)