Hide header or field name in subform

Posted on 2004-10-28
Last Modified: 2008-02-01

I have a subform which has source object from a table. My question is how can I hide the headers or field names in the subform?

thanks in advance
Question by:ishadowme
    LVL 8

    Expert Comment

    Hi ishadowme,

    Change the sub form view, from datasheet view to form view and design the layout you desire.


    Author Comment

    Hi Sashp,

    Maybe I didn't make my question clearly, let me try it again.

    I have a main form and a subform inside it. My subform links to a table. What I have right now is when I open the main form, my subform will show everything from the table (field names, records...). What I want to archive is my subform will only show records without any field name on top of it.

    LVL 8

    Expert Comment

    As SashP said, the subform may be in datasheet view, if not delete the labels, if it is in datasheeetview, change to continuous form and remove the labels, as well dont show page header in the subform. To do this, go, in design mode, to View menu and uncheck Page header and form header.

    LVL 58

    Accepted Solution

    You can't (I think) hide the column titles in a datasheet view... However, you can set them to " " (i.e. without text).

    If the subform is an actual form (Access 97), then set the label associated with each control to " ".

    If the subform is just a datasheet, open the recordsource, display the field properties and put " " as Caption. (You may want to use Alt+0160 instead of space, though.)

    If that is not acceptable, be prepared to do a lot of coding to have a continuous form behave like a datasheet.
    Oh, yes, you can also use a list box, if there is no editing required and if you don't need to display numbers...

    I hope this helps.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    857 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now