Hide column headings

[DBL]

Does anyone know if I can hide the column headings in datasheet view?

 

[Jimbob]

I don't think you can, but what you could do is use a cintinuos form and emulate a datasheet view....that way you can remove the column header labels

 

[Jimbob]

I don't think you can, but what you could do is use a continuos form and emulate a datasheet view....that way you can remove the column header labels

 

[DBL]

Thanks for that JimBob, I'll give it a go.

 

[vineet]

Hi JimBob,
I know its a quite late reply to this post.
I need the exact same thing as Mr. DBL has asked here i.e hide column headings in a datasheet view in MS Access.
Can you please ellaborate on your solution. How exactly should I proceed.
How can I use continuous form to emulate the datasheet view.What exactly you mean by it?
I would be very grateful to you, if you could help me into this.

Regards,
Vineet

 

[Galaxiom]

Design the form with all the controls in a row up against each other.
Delete their labels. (You may have to delete their layout setting first if they were created by the form wizard.)

 

[vineet]

Hi Galaxiom,
Thanks very much for your reply.
I did what you suggested but in vain. I deleted all the labels and placed all the controls(i.e textboxes) in one row up against each other.
i even created a new form from scratch using "Create form in Deign view". Placed all the labels in one row in the new form. But when I run the form in datasheet view, access picks up the name of those textboxes and display them as the column heading.
I have attached a pic with this post.
text0 is the name of 1st textbox.
Text3 is the name of 2nd textbox.
I want the column headings i.e text0 and Text3 to be removed.
Could you please help me into this?

 

[boblarson]

You can hide columns in datasheet view. It really is no problem.

Check out this about datasheets.

 

[vineet]

Hi Bob,
I dont want to hide columns but I want to hide the headings of some of the columns.
e,g.
Suppose we have following scenario:-
Name ID Department
Jen 1 Arts
Kim 2 Science
Jim 3 Engineering

Then I want only the data to be displayed i.e. Name,ID and Department (column headings) should be invisible.
I hope you understand it.

Vineet

 

[boblarson]

Hi Bob,
I dont want to hide columns but I want to hide the headings of some of the columns.
e,g.
Suppose we have following scenario:-
Name ID Department
Jen 1 Arts
Kim 2 Science
Jim 3 Engineering

Then I want only the data to be displayed i.e. Name,ID and Department (column headings) should be invisible.
I hope you understand it.

Vineet

Oh, I misunderstood. Then, yes you'll need a continuous form for that.

 

[vineet]

Bob,
Isnt it possible in datasheet view?I dont want the data in continuous form.

 

[boblarson]

Bob,
Isnt it possible in datasheet view?I dont want the data in continuous form.

Nope, to remove specific headings you will need to use continuous form view formatted to look like a datasheet. Sorry, that's just one of the limitations of Access.

 

[Kryst51]

What about using a list box, then creating your own column headings above the list box? That could be a work around.

Edit: Nevermind, stupid thought, you can't enter or edit data that way!

 

[Galaxiom]

Placed all the labels in one row in the new form. But when I run the form in datasheet view, access picks up the name of those textboxes and display them as the column heading.

The datasheet without headings is emulated by a continuous form with all the controls against each other in a row. Put the form into continuous view and all the rows appear under each other with no headings.

 

[missinglinq]

Is your real desire to have no column headings, or is it that you don't want the field names showing? If you base your datasheet form on a query that is based on your table, you can assign your own names to the columns.

 

[vineet]

Is your real desire to have no column headings, or is it that you don't want the field names showing? If you base your datasheet form on a query that is based on your table, you can assign your own names to the columns.

I do not want column headings at all.
@Galaxiom: Thanks very much for your help. I did the exactly same thing you said and it worked wonders.
Thanks very much for your help. But I wonder why Microsoft cant keep things simple? lolz

 

[missinglinq]

It's not a matter of keeping things "simple," it's a matter of having things display in the manner that most developers/users want them displayed.

When you have a new form, with no records in the underlying table/query, how would the user know what data goes in what textbox, without labels?