To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101153 Issue #|101153 Summary|Ampersand in first char on form listboxes Component|Database access Version|OOo 3.0.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ttreker
------- Additional comments from ttre...@openoffice.org Fri Apr 17 08:44:46 +0000 2009 ------- If an ampersand is the first character in an item in a list used for a listbox on a form, then the dropdown (or no-dropdown) list does not display. Further, all other listboxes on the form are effected in the same way. This last point is true regardless whether a particular listbox has an item with an ampersand as its first character. In other words 1 bad apple spoils the whole bunch. Here are the exact circumstances in which I discovered this: 1) Had a table with a field (call it TAB1 and FLD1) that needed a selection list for that field. 2) Setup a support table (call it LTAB1 with LFLD1) with that list. 3) Using proper tables with autogenerated primary integer ID field keys, I setup a 1:n relationship between the list table and the main table of interest. 4) Created a query (call it QRY_LB_LTAB1) on the LTAB1 table of the form conducive to supporting listboxes: i.e. "SELECT LFLD1, ID FROM LTAB1". 5) Created a form for the main table. 6) In the form editor, I selected the selected the control for the FLD1 field. I changed the control to a listbox. 7) I set the listbox control to dropdown, and set its data to a query pointed to my QRY_LB_LTAB1 query. 8) Added safe data (no ampersand in first character position). Dropdown works. 9) Added an item with an ampersand in the first char position. Listbox dropped down empty. 10) Added other listbox fields configured the same way. They failed the same way. My work-around is to add dummy chars ahead of the ampersand. This does not present a problem on a table control, just a stand-alone field on a form. I found the problem on 2.4 on OS X on a PPC but tested it on a Dell XP laptop patched to date. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
