G: Yes, you can change the label in a LibreOffice Base form to display the contents of a field in the current record. To do this, you'll need to use macros in LibreOffice, as there is no direct built-in feature for dynamically changing a label based on record content. Here’s a simple outline of how you can achieve it:

1. Create a Form: Make sure your form contains the field whose value you want to display and a label that you want to update.

2. Add a Label and Text Box: Insert a label (static text control) and a text box (or other field control) bound to the database field.

3. Create a Macro:

   • Go to Tools > Macros > Organize Macros > LibreOffice Basic.
   • In the dialog, create a new macro that will update the label text based on the field content.

4. Sample Macro:

   Sub UpdateLabel
       Dim oForm As Object
       Dim oLabel As Object
       Dim oField As Object
   
       ' Get the form and the field control
       oForm = ThisComponent.DrawPage.Forms.GetByName("MainForm") ' Adjust to your form's name
       oField = oForm.GetByName("FieldControlName") ' Adjust to your field's control name
       
       ' Get the label control and update its text
       oLabel = oForm.GetByName("LabelControlName") ' Adjust to your label's control name
       oLabel.Label = oField.Text ' Set the label's text to the field's value
   End Sub

5. Assign the Macro:

   • Assign this macro to the form's After Record Change event. This way, whenever you navigate to a different record, the label will update to show the current record’s field value.
   • To do this, right-click the form, select Form Properties, then go to the Events tab, and assign your macro to the After Record Change event.

Once set up, the label should change dynamically based on the current record's field content.