[Solved] Hide field names when displaying table content
[Solved] Hide field names when displaying table content
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].
Reason: Tagged [Solved].
OpenOffice 4 Windows 7
Re: Hide field name
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Hide field name
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.
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
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11