table data not visible in form

English
#1

I am using LibraOffice Base 6.4.5.2 (x86) on a windows 10 desktop - full details at the end.

I am building a database incrementallly to record organisation details, including addresses, some dates and a logo image. At the moment I have only created one form to enter data and I am trying to get that working before I start. There are 80 records in the form.

The first field is IDno, is the Primary Key and the field type is an Integer

The second field is labelled ForceID. Its type is "Text [VARCHAR]. Field properties are set as Entry required; Length 40; Default {not set]; Format example {@ character is shown, but I didn’t set it}.

When I open the .odb in forms, the second field is black, for every record. Almost all the other details are visible as you advance through the records.

No matter what I do, I cannot make the data in the second field visible. I don’t know what I have done wrong, but something has obviously happened when I designed and created the form.

Any suggestions about how to make details visible would be appreciated.

Thank you for reading my question

Norman W

Version: 6.4.5.2 (x86)
Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6
CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: default; VCL: win;
Locale: en-GB (en_GB); UI-Language: en-GB
Calc: threaded

#2

Don’t post multiple times! You don’t get more opportunities for answer and you’re confusing contributors who no longer to which occurrences they should answer.

Delete the other occurrences.

Duplicate of 258207/table-data-not-visible-in-form and 258208/table-data-not-visible-in-form

#3

Thanks for deleting the dupes.

However, there is another “detail” about this site: it is a Question & Answer one, not a forum. Consequently, answers are reserved for solutions. They aren’t available for a discussion, all the more because the site engine reorders the answers according to an internal algorithm and any chronological relationship is lost.

So, please, delete your “non-solution” or use the more link (only you as the answer owner can see it) to repost as a comment if you think it’s worth to be kept.

#4

Hello,

First thing not stated is if looking at the data directly in the table reflects no problem. It would seem you can see it there. If so it is a problem with the control on the form.

You stated:

No matter what I do, I cannot make the data in the second field visible.

but have not stated what you actually tried.

Also:

When I open the .odb in forms, the second field is black, for every record. Almost all the other details are visible as you advance through the records.

What other details are NOT visible?

There are a few things I would attempt. If uncomfortable with this, just make a copy of the Base file first.

On the Form with the problem, add a text field and set the data to the problem field. Display OK? Then delete the problem control. Same problem? Create a new form using the wizard and see if the problem is resolved.

Still a problem? Try resetting the user profile. See LibreOffice user profile

#5

Thank you for replying to my question.

I have tried so many different settings in form properties, I have lost track of what I have tried, hence my comment, “no matter what I do”.

Another two out of 20 fields are randomly blank. In the table all the data is present,. So for the second field NO data shows in the field in forms, whereas random data shows in the other two fields where there is a problem. All other fields deliver data to the form.

IAfter backing up, I added an additional field as you suggested. The problem is still there.

Creating a new form will not be a quick job, so I tried resetting my user profile. The problem is still there.

#6

@NormanW,

Must be something in a setting somewhere. Possibly best if you could post a copy of the Base file. You can attach to original post using the paperclip icon when editing (toolbar in upper left of editing question).

#7

This is an old conversation, based on an older version of LibreOffice, but I have just come across a similar problem when upgrading to LO 7.1.8 (with MacOS 10.13.6): certain fields in forms I have long been using have suddenly gone black, except when they have focus, at which time they are legible and behave normally. I have pinned this down to columns in a table-grid which are defined as supporting multi-line input: if I change the property to ‘No’ the display problem goes away (but so does the word-wrapping!). This seems very specific and should perhaps be reported as a bug.

#8

Does the issue occur with my database forms too? https://ask.libreoffice.org/uploads/short-url/nW2PUGMTAXtJcBy67iiy8RvNj8m.odb contains 2 forms with subforms, listboxes, table controls and listboxes in table controls.

#9

The only table-grid text-box column in your forms is that headed ‘N’ on “Persons with sub-form”. If I set this to ‘Multi-line input’, yes it goes black! (This doesn’t happen with the list-boxes, but they do not offer a multi-line option.)

Incidentally, having had this problem with LO 7.1.8, I have reverted to 7.1.6.1 - and I have the same problem, so I think I must now go back further to discover the most recent release where this does not occur!

#10

Thank you. I was not aware that text fields in table controls could be multi-line. Whenever I need multi-line text in a form, I draw a (additional) separate text box outside the table grid.
I can’t reproduce the display issue with LO 7.2, LO 6.0 nor AOO on Linux. It might be related to Mac OS. I’d recommend a separate text box anyway.

#11

Thank you. This is very odd. I have now verified that my last update to LO was version 7.0.6.2 (7 May 2021). While waiting to reinstall that, I recorded a screenshot of one of the misbehaving forms and - this is way beyond my pay-grade! - the screenshot shows everything (while, looking at the screen, the entire ‘Basis’ column apart from the highlighted record, is black)!

Screen Shot 2022-01-19 at 15.33.27
Screen Shot 2022-01-19 at 15.33.272864×1674 504 KB

Now, even stranger, that screenshot loaded into Mac ‘Preview’ shows all those ‘Basis’ records with a gray background apart from the one that has focus (white), while here after uploading, ALL of them have a white background! This must be somewhere deep in the management of graphic data.

… Now I have reinstalled LO 7.0.6.2 and the problem has disappeared. Mightily relieved, but utterly confused!

#12

I have never seen anything like your screenshot. While inline, the “Basis” column is displayed with black font on white background. The columns to the left are black on light grey. While in overlay view (after clicking on it), the “Base” column is black on dark grey.

This is an example of the workaround:
t55271.odb (18.0 KB)

#13

Have noted this here → LO7122 Formatting issues
Do not know if this was ever reported as a bug.

#14

Indeed so! I had not imagined that the problem would reproduce itself in this way! Thank you for the workaround, which I had already employed for texts that overrun the two lines provided in the table: see screenshot below (back with LO 7.0.6.2). Another curiosity here is that (as you see from the screenshot) I had provided for the additional panel to be visible only when the ‘Basis’ field was double-clicked. After the update, the software failed to respond to the double-click on that field!

Screen Shot 2022-01-19 at 20.28.25
Screen Shot 2022-01-19 at 20.28.251849×1080 357 KB

#15

Yes, Ratslinger, this seems to be related. I couldn’t see a relevant bug report, but I am not well up in reporting bugs and so do not know my way around very well. Clearly the problem has been there for a while, but the circumstances are rarely created.

#16

It is simply multi line text column in a table control. However, just tested again with:

Version: 7.2.5.2 / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

and the problem seems to no longer exist. Don’t know when this changed.

#17

Thank you. Have downloaded and installed so many different versions today that I rather lost courage - but I shall try LO 7.2.5.2 (without deleting the older version)!

… and now I have installed LO 7.2.5.2 and this particular problem has gone away! Sorry to have bothered anyone with this (but still utterly mystified by it).
.
Version: 7.2.5.2 / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 8; OS: Mac OS X 10.13.6; UI render: default; VCL: osx
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.