Ask Your Question

table data not visible in form

asked 2020-08-02 14:57:36 +0200

NormanW gravatar image

I am using LibraOffice Base (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: (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

edit retag flag offensive close merge delete


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

ajlittoz gravatar imageajlittoz ( 2020-08-02 15:59:22 +0200 )edit

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.

ajlittoz gravatar imageajlittoz ( 2020-08-02 16:45:05 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-08-02 17:59:50 +0200

Ratslinger gravatar image


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.


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

edit flag offensive delete link more


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.

NormanW gravatar imageNormanW ( 2020-08-02 20:29:47 +0200 )edit


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).

Ratslinger gravatar imageRatslinger ( 2020-08-02 21:07:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-08-02 14:57:36 +0200

Seen: 37 times

Last updated: Aug 02