[Solved] Transparent Textbox problem

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

[Solved] Transparent Textbox problem

Post by dreamquartz »

Hello All,

I would like to accomplish the following:
The 'appearance' of 1 Textbox showing content of different sources.
I have a form called fNotesMade that shows an overview of alle the Notes, recorded in tNotesMade, that were made, related to anything in the database.

The table tNotesMade looks like (see picture)

I would like to show the info about the related City, for which tCity.CityID=tNotesMade.FKCityID is applicable, in the same location as for the info about the related Person, for which tPerson.PersonID=tNotesMade.FKPersonID is applicable.

I seem not to be able to have fields become transparant, so that they can overlap on top of each other, which would be a simple solution.
Wrapping also does not provide a solotion.

Any suggestions are appreciated,

Dream
Attachments
tNotesMade.png
tNotesMade.png (12.88 KiB) Viewed 2739 times
Last edited by dreamquartz on Tue Mar 28, 2023 5:17 pm, edited 1 time in total.
LO 7.x, HSQLDB 2.7.x & Ubuntu 22.04 LTS.
UnklDonald418
Volunteer
Posts: 1549
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Transparent Textbox problem

Post by UnklDonald418 »

Base form controls have a boolean EnableVisible property. It might be a little tricky to design the form but you could place one control on top of the other then with a macro toggle the EnableVisible properties showing one or the other.
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: 881
Joined: Mon May 30, 2011 4:02 am

Re: Transparent Textbox problem

Post by dreamquartz »

Thank you,

That will help a lot.

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