Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / April 2008

Tip: Looking for answers? Try searching our database.

Down Arrows in Subform Header

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DavidSteel - 15 Apr 2008 22:39 GMT
I have several databases that were created in Access 2003 and earlier.  
Several have forms where the main form is one record and the subform has
several records.  For instance, the header record would have a trip number,
truck number and driver.  The subform would have all the stops for that trip.
Now, I just was updated to Office 2007, including Access 2007.
In Access 2007, it has added a Down Arrow to the right of each column header
in the subform.  If you click on this, it gives you choices to sort by that
field, etc.
The problem is that it obliterates part of the name of the field.  I would
have to go and resize several fields on several forms.  Personally, I don't
want users to have the access of this as there is a specific reason for the
order of these records.
So how do I turn this feature off?

Thanks for any help you can provide,

David
Dirk Goldgar - 15 Apr 2008 23:02 GMT
>I have several databases that were created in Access 2003 and earlier.
> Several have forms where the main form is one record and the subform has
[quoted text clipped - 15 lines]
> order of these records.
> So how do I turn this feature off?

I don't know if you can turn it off for datasheets.  I've only been working
with Access 2007 for a short time though, so there may be a way I don't know
about.

However, you can replace your datasheet subforms with subforms in continuous
forms view.  You can play with their formatting if you want, so as to make
them look like datasheets if you want, but they won't show those arrows and
options.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

DavidSteel - 16 Apr 2008 14:27 GMT
Hi Dirk,

Thanks for your answer.  I had a feeling that it may be something that
cannot be turned "off".  Your method may solve the problem but seems it would
also mean a lot more work, just to make the Arrows go away, rather than
resize.

Sincerely, David

> >I have several databases that were created in Access 2003 and earlier.
> > Several have forms where the main form is one record and the subform has
[quoted text clipped - 24 lines]
> them look like datasheets if you want, but they won't show those arrows and
> options.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.