Access 2007 Datasheet Field dropdown menus

[GohDiamond]

Our office is planning to switch over to MS Office 2007 including Access 2007. I've just been looking into converting our Access 2003 databases to the new version. One thing I noticed about the datasheets appearing as subforms is that each field header/label/caption/column selector thingie has a dropdown menu. The down arrow of the dropdown menu takes up valuable realestate where the field name is being displayed.

Question:
Is there a way to turn off those individual datasheet dropdowns and get rid of the arrows so that the form doesn't have to be redesigned, due to increased column width considerations which the down arrows cause, just to display the full field labels as they always have been in Access 2003?

Thanks in advance for any help!

Cheers!
Goh

 

[David Eagar]

Not sure about datasheets, I don't use them, but you might try, Access Options, Current Database, untick Display Document Tabs

 

[GohDiamond]

Thanks for the suggestion. I tried it, but that doesn't seem to be the solution. Anybody else have any idea how to get rid of those annoying column header dropdown menus?

Goh

 

[David SR]

I'm desperately trying to find an answer to the same question.

Someone out there must know the answer, surely.

 

[David SR]

Help, please!

 

[David SR]

Bump up again.

 

[David SR]

Is there nobody out there who can answer this question?

 

[David SR]

Any ideas, anybody?

 

[Jenn Dq]

Did anyone ever figure this out? I am need of the answer also.

Jenn D.

 

[Jenn Dq]

I got it... I stumbled on it quite by accident .

In the Form's Property Sheet, on the "Other" Tab is property "Shortcut Menu"... set this property to "No". Those annoying, real estate hogging arrows go away!

Jenn D.