Access 2007 - Allow Design Changes Property

C

Crash_Pie

Registered User.

Local time

Today, 22:24

Joined

Feb 15, 2007

Messages

36

• Jul 22, 2008

• #1

Hi

Firstly, sorry if this is already answered elsewhere in this forum, I've searched for a couple of nights and can't find the answer (how do you search when some words are disallowed?).

Anyway, the real question: We use Access 2003 at work and I design/modify our database using Access 2007 at home. It looks like the form property Allow Design Changes has been removed from the property sheet in 2007. So how do I set this property to Design View Only using 2007?

Thanks for any assistance.

Crash

 

C

Crash_Pie

Registered User.

Local time

Today, 22:24

Joined

Feb 15, 2007

Messages

36

• Jul 23, 2008

• #2

 

RuralGuy

AWF VIP

Local time

Today, 04:24

Joined

Jul 2, 2005

Messages

13,825

• Jul 23, 2008

• #3

I've never used that property. How is it affecting your project?

 

C

Crash_Pie

Registered User.

Local time

Today, 22:24

Joined

Feb 15, 2007

Messages

36

• Jul 25, 2008

• #4

Hi RG

Basically this option stops the Property Sheet from appearing in Form View. I discovered recently I had accidentally left this option set to All Views on some forms which meant users could see the form property sheet when I didn't want them to. I managed to turn this property off (set to design view only) by using the 2003 version at work. However I can't seem to do it using 2007 from the property sheet itself. Is there a way of doing this in code?

Thanks

 

RuralGuy

AWF VIP

Local time

Today, 04:24

Joined

Jul 2, 2005

Messages

13,825

• Jul 25, 2008

• #5

I haven't found anything so far. Sorry.