[Solved] Hide field names when displaying table content

Discuss the database features
Post Reply
Glen59
Posts: 5
Joined: Wed Dec 15, 2021 8:59 pm

[Solved] Hide field names when displaying table content

Post by Glen59 »

Is there a way to hide field names in a Database? Sometimes I just want to see the fields not the field name when I go to the table that I created.
Last edited by Hagar Delest on Fri Dec 17, 2021 12:00 am, edited 1 time in total.
Reason: Tagged [Solved].
OpenOffice 4 Windows 7
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Hide field name

Post by Villeroy »

Database tables show raw data under column names. Cheating yourself (the database developer) about column names makes no sense. You must not use tables and queries as a user interface. Forms and reports are the user interface where you can rename anything anyhow or not at all.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
UnklDonald418
Volunteer
Posts: 1546
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Hide field name

Post by UnklDonald418 »

Use the Form Wizard to create a new form.
In the first step of the Wizard select your table name
and then select all the fields you want to see on your form. You will need to include the Primary Key field if you want to be able to edit the data in your database.
If doesn't sound like you will need a SubForm, so skip to Step 5 (Arrange Controls)
The Wizard usually defaults to the Data Sheet (Table Control) but make sure that is selected.
Skip to Step 8 where you can enter a name for your form or accept the default.
Select the Modify Form option and select Finish.
The Wizard will create a form with table on it
Right click on the column heading you want to modify and select Column
That will open a Properties dialog.
On the General tab look for Label property.
You can erase all the characters
Close the Properties dialog
When you right click on a column heading you can also choose to Hide Column, then neither the heading nor the data will be displayed. This is often used to hide an auto generated primary key column.
Save the changes to the form, Ctrl-S will do that
Along the left margin near the top select Design Mode On/Off and your data should appear with the blank column heading.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Glen59
Posts: 5
Joined: Wed Dec 15, 2021 8:59 pm

Re: Hide field name

Post by Glen59 »

Thank you for the answer.
OpenOffice 4 Windows 7
Glen59
Posts: 5
Joined: Wed Dec 15, 2021 8:59 pm

Re: Hide field names when displaying table content

Post by Glen59 »

Thank you Donald.
OpenOffice 4 Windows 7
Post Reply