[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Hide header or field name in subform

Posted on 2004-10-28
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 12430989
Hi ishadowme,

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


Author Comment

ID: 12431263
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.


Expert Comment

ID: 12431351
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

harfang earned 200 total points
ID: 12431500
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.

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

656 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