Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

You can sort of do this using macro code. You can set the Visible property of the text field to Yes or No depending upon the setting of the radio button group (use group so only one selection allowed). If you know macros this is fairly simple. If not, learning to code macros is quite a task. Many thing to cover especially in Base.

Personally, I am not sure of the benefit. If you select Yes but don't enter a name, what then? You can always use SQL (a query) to check for records with incorrect entries such as: Married set but spouse = NULL (or vice versa).

Hello,

You can sort of do this using macro code. You can set the Visible property of the text field to Yes or No depending upon the setting of the radio button group (use group so only one selection allowed). If you know macros this is fairly simple. If not, learning to code macros is quite a task. Many thing to cover especially in Base.

Personally, I am not sure of the benefit. If you select Yes but don't enter a name, what then? You can always use SQL (a query) to check for records with incorrect entries such as: Married set but spouse = NULL (or vice versa).

Edit 2018-06-19:

To illustrate a working sample with macro ------ RadioButton.odb

For information on coding macros there are many sources such as the LO docs -> LibreOffice Base Handbook.

The most definitive source for macros is OpenOffice Macros Explained (OOME) by Andrew Pitonyak found here -> OOME PDF.

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

Hello,

You can sort of do this using macro code. You can set the Visible property of the text field to Yes or No depending upon the setting of the radio button group (use group so only one selection allowed). If you know macros this is fairly simple. If not, learning to code macros is quite a task. Many thing to cover especially in Base.

Personally, I am not sure of the benefit. If you select Yes but don't enter a name, what then? You can always use SQL (a query) to check for records with incorrect entries such as: Married set but spouse = NULL (or vice versa).

Edit 2018-06-19:

To illustrate a working sample with macro ------ RadioButton.odb

For information on coding macros there are many sources such as the LO docs -> LibreOffice Base Handbook.

The most definitive source for macros is OpenOffice Macros Explained (OOME) by Andrew Pitonyak found here -> OOME PDF.

For more, see this post -> To learn LibreOffice Base are there introductions or tutorials?

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.