[Solved] Textbox without headers?

Discuss the database features
Post Reply
dreamquartz
Posts: 884
Joined: Mon May 30, 2011 4:02 am

[Solved] Textbox without headers?

Post by dreamquartz »

Hello All,

Trying to find a solution to the following:
Writer form, used as entry form from Split Base (HSQLDB 2.7.2, LO 24.2.2).
Text boxes for different entries.

1 Box used for Notes related to Addresses.
I seem to be unable to not show the "Notes" column header in the box. It takes space on a form with already to much info.
I like to keep the textbox header: 'Notes Address", but drop the column header: "Notes".
Please screenshot below.

Is this possible?

Thanks in advance,

Dream
Attachments
Screenshot from 2024-04-27 10-47-49.png
Screenshot from 2024-04-27 10-47-49.png (2.46 KiB) Viewed 539 times
Last edited by dreamquartz on Fri May 03, 2024 6:07 am, edited 1 time in total.
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
User avatar
DiGro
Posts: 179
Joined: Mon Oct 08, 2007 1:31 am
Location: Hoorn NH, The Netherlands

Re: Textbox without headers?

Post by DiGro »

Open form in mode Edit.

Shift+click on the "Notes" label.

Delete it
____________
DiGro

AOO 4.1.15 (Dutch) on Windows 11. Scanned with Ziggo Safe Online (F-Secure)
dreamquartz
Posts: 884
Joined: Mon May 30, 2011 4:02 am

Re: Textbox without headers?

Post by dreamquartz »

@DiDro,

Thanks for the response, but I want to remove the other one, being the Column Header "Notes" not the Textbox Label, called "Notes Address".

Dream
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
UnklDonald418
Volunteer
Posts: 1551
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Textbox without headers?

Post by UnklDonald418 »

the Column Header "Notes"

Table Controls have column headers, Textbox controls do not.
Column Headers in Table controls cannot be removed without disconnecting the columns from their data source.
From the screenshot It appears that you have only one column in the Table control so simply replace it with a Textbox control connected to the Notes data source.
If you continue to have issues with this please upload a sample .odb file with the Form you need to edit.
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
dreamquartz
Posts: 884
Joined: Mon May 30, 2011 4:02 am

Re: Textbox without headers?

Post by dreamquartz »

@UnklDonald418

That works wonderfully very well.
Created a simple textbox in Writer and linked it to the source table tNotes from the DataBase for testing.
Added and linked a label field to the textbox.

It worked as was required.

Grouped the label field and the textbox, and copied the group to a form called fCompany in the DataBase.
When editing the form, there were 2 subforms on the bottom created in my case.
One held the text box and the other held the label field.
Brought the 2 together in one of the forms, and re-linked the label field to the textbox, because that link was severed.

Added a form fAddressNotes as a subform to the form fAddress, being itself a subform to the form fCompany in the DataBase, linked the 2, and dragged the group to its final destination.
Removed both the empty forms that were left behind from moving the textbox plus its label to its final destination, and voila the result is now a textbox with NO Column Header, but with a label field.

Thanks for your suggestions,

Dream
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
Post Reply