 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 2007key fields not visible in combo box
An application I wrote 3 years ago no longer works after applying SP3 to Office 2003. Unbound combo boxes used to display 2 columns but now the first column is blank (it is a key field). This occurs in every instance I have used combo boxes that attempt to display the first column of multiple column drop-downs. Solution?  SignatureMike By chance, is the field to which the combobox is bound is a text field and has a Format property setting for the field in the table? If yes, this is a bug that has been reported by many ACCESS users during past weeks. It apparently is a bug in Office 2003 SP3, which was released by MS some weeks ago. MS is aware of the bug and is working on how to fix it. In the meantime, the "complete workaround" is to remove the Format property's value from the field's properties in the table's design view. Otherwise, concatenating the field's value with an empty string also seems to "overcome" the problem. SignatureKen Snell <MS ACCESS MVP> > An application I wrote 3 years ago no longer works after applying SP3 to > Office 2003. Unbound combo boxes used to display 2 columns but now the [quoted text clipped - 3 lines] > column > drop-downs. Solution? "Combo box controls and list box controls display no value or incorrect values in Access 2003 after you install Office 2003 Service Pack 3." And a few more problems SP3 introduced. Description of the Access 2003 post-Service Pack 3 hotfix package: December 18, 2007 - 945674 http://support.microsoft.com/kb/945674 SignatureKen Snell <MS ACCESS MVP> > By chance, is the field to which the combobox is bound is a text field and > has a Format property setting for the field in the table? If yes, this is [quoted text clipped - 15 lines] >> column >> drop-downs. Solution? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.