2009/10/1 Drew Jensen <[email protected]>: > Dotan Cohen wrote: >> >> I am creating a form in OOo base but I need help with two form >> elements that I cannot figure out how to create. I have been googling >> and reading tfa for some hours (including some old posts of my own) >> but these issues remain: >> >> 1) Dropdown box of suggested data for varchar field >> My database has a varchar field. In practice, the data being entered >> into this field would most likely be A, B, or C, but there needs to be >> the option to add other data. Therefore, I would like to have a hybrid >> dropdown box / single-line text area that lets the user either select >> A, B, or C from the dropdown list, or alternatively enter his own >> value via keyboard. >> > > Hi Dotan, > > Use a Combo Box, in place of the List Box, and you have what you want. >
Thanks, but I cannot for the life of me figure this one out. I have been googling all morning. Let's suppose there is a varchar field called "fruit". I would like the Combo Box to display "apples", "oranges", and "pears" but give the user to option to overwrite one of these selections. How does one configure the combo box as such? > Not sure I understand - are you asking about having the form auto populate > the control with the current DateTime or Date? > Yes. Suppose that I have a timestamp field in the format: YYYY-MM-DD HH:MM:SS. How do I make the control that is automatically populated with the current time/date, yet lets the user override to a different time/date? Thanks! -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
