On Sat, 2006-04-08 at 20:09 +1000, Declan Mullen wrote: > 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 > How about using a list box with a blank entry as the first entry?
Matt Needles --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
