Hi,
Within OpenOffice v2.0.2, how to configure a combo box or list box
control to limit values but allow the Del key clear the value ?
For example:
I have created a table (ie "List of Towns") that contains a list of
acceptable values for another field (ie "Town") in another table (ie
"Address").
The "Town" field is a varchar that is to contain the name of a town,
rather than an ID integer. The "Town" field must be limited to being
empty (null or empty string) or having one of the values from the "List
of Towns" table. No other values are acceptable.
I've create a form with a table control for the "Address" table.
For the "Town" field/column in the table control, I want the user to be
able to either select (or enter) a value from the list of acceptable
values or clear the field by hitting the Del key, but I do not want them
to be able to enter alternative values.
First I tried making the "Town" field a combo box. This allows the user
to delete the field and select from the list of acceptable values,
however I do not know how to configure it to stop the user from entering
in any other values they want. Can it be configured that way ?
Then I tried making the "Town" field a list box. This limits the user to
the list of acceptable values, but it prohibits the user from clearing
the field via the Del key. Can it be configured to allow the Del key ?
Many thanks,
Declan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
