Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

There is no 'one-line limitation' in a memo field. You just need to set the control properties (Text type) to accept multi-line:

image description

Being new to Base, here is a link to the documentation -> LibreOffice Base Handbook.

Now what really sounds strange is that you think you need 100+ fields (or even lines). This actually sounds as though the design of your table/database is incorrect. Possibly needs splitting into two tables with a one-to-many relationship. Unfortunately, you don't explain your reasoning for this.

Hello,

There is no 'one-line limitation' in a memo field. You just need to set the control properties (Text type) to accept multi-line:

image description

Being new to Base, here is a link to the documentation -> LibreOffice Base Handbook.

Now what really sounds strange is that you think you need 100+ fields (or even lines). This actually sounds as though the design of your table/database is incorrect. Possibly needs splitting into two tables with a one-to-many relationship. Unfortunately, you don't explain your reasoning for this.

To your original question, you can add fields at the end of a table by editing the table - right mouse click & select Edit. See the documentation for more info.

Hello,

There is no 'one-line limitation' in a memo field. You just need to set the control properties (Text type) to accept multi-line:

image description

Being new to Base, here is a link to the documentation -> LibreOffice Base Handbook.

Now what really sounds strange is that you think you need 100+ fields (or even lines). This actually sounds as though the design of your table/database is incorrect. Possibly needs splitting into two tables with a one-to-many relationship. Unfortunately, you don't explain your reasoning for this.

To your original question, you can add fields at the end of a table by editing the table - right mouse click & select Edit. See the documentation for more info.

Edit 2018-03-23:

First a comment - There were plenty of methods to back up data, files, or entire images with Win 98 and even before that. Used those methods on a regular basis. You could even use removable hard drives (albeit small in capacity) or CD's. It was NOT an OS problem.

Above is a link to the LO documentation. There is an entire chapter for Tables & another for Forms. It is surprising you found nothing there as the chapter on Forms has an entire section on Properties.

To get the properties of a control, select the control with a left mouse click, then right mouse click the control (this presents the context menu) and select Control. You should only be selecting a control and not a label with it. If both label & control are selected, hold down Ctrl key when selecting. The item noted above in original answer is on the General tab. Set it to Multi-line as shown. Single line is why pressing enter goes to the next control.

Adding fields to a table is Edit the table, then on a new line after the end of the other fields, create a new field by entering a field name then a field type and properties if needed. Again, refer to the chapter on Tables as there is too much ground to cover here.

Base and databases are not something to be grasped in a few hours, days or even weeks. You need to go through the documentation. There are many good examples there.