Form controls propergies

[moi]

Hello sirs,
I encounter unsual on my acc2007.. Suddenly wben im on form design, i could not open/display the properties of the form and its controls..

 

[pbaldy]

Make sure the edge didn't get dragged all the way to the side of the screen. If it has, you should be able to grab it and widen it back again.

 

[moi]

Make sure the edge didn't get dragged all the way to the side of the screen. If it has, you should be able to grab it and widen it back again.

Thanks for the quick reply.. I could not get what exactly you mean sir, pls expand a bit.

 

[pbaldy]

At first glance you may think the properties window is gone here, but if you look closely you can see the edge of it has been dragged very close to the edge of the Access window.

 

[moi]

The edge of the acc windows is there, but my active design view of the form when i, click right button of the controls it did not show the property sheet.. Like if i wanted to hide the controls, it didnt give me the property sheet.

 

[Gasman]

How about showing us a picture?

 

[moi]

Pls see ttached.. It shows the property of the form when i clicked the upperleft corner of the form in design view.. But it will not display the property sheet of the form or the controls on it.

 

[pbaldy]

Can you post a pic of the entire Access window after clicking on Properties?

 

[pbaldy]

Also make sure it didn't get undocked and sitting behind the form or something.

 

[moi]

Also make sure it didn't get undocked and sitting behind the form or something.

There is no other form or object active/open sir.. I tried to export the objects (table, query and form) to a new blank database but still same..

 

[isladogs]

As @pbaldy has already stated, this is almost certainly due to the property sheet being accidentally moved 'off-screen' and/or shrunk to almost nothing. You should be able to restore it by typing one line of code in the VBE immediate window

Application.CommandBars("Property Sheet").Position = 2

For more information/explanation, see my article:

Reset the Property Sheet

This article explains how to reset the property sheet if it cannot be found after resizing or relocation

www.isladogs.co.uk