If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form Combo Box blank in ver 2003 - created in 2007 as 2002-2003
I am new to Access and have Vista 64 with Access 2007 and XP with 2003. I
created a database in the 2007 ver as a 2002-2003 and when I opened it in 2003 there were no error messages but a major combo box drop down is blank. I went back to the 2007 ver with the same file and it opened fine. There are appox. 80 small records in the Lookup Table that is not showing. Any ideas? Thanks. |
#2
|
|||
|
|||
Form Combo Box blank in ver 2003 - created in 2007 as 2002-2003
If you have SP3 installed for Access 2003, there is a bug that can cause this
behavior. And there is a hotfix for it. Check Allen Browne's site http://allenbrowne.com/bug-Access2003SP3.html You might check the properties of the combobox and make sure the column count is equal to the number of columns being passed by the source. I have found that sometimes this works to fix the problem. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County CDS wrote: I am new to Access and have Vista 64 with Access 2007 and XP with 2003. I created a database in the 2007 ver as a 2002-2003 and when I opened it in 2003 there were no error messages but a major combo box drop down is blank. I went back to the 2007 ver with the same file and it opened fine. There are appox. 80 small records in the Lookup Table that is not showing. Any ideas? Thanks. |
#3
|
|||
|
|||
Form Combo Box blank in ver 2003 - created in 2007 as 2002-200
John,
I do have SP3, so I will start with the fix and check the columns. Many thanks for the advise. I had no idea where to start. CDS "John Spencer" wrote: If you have SP3 installed for Access 2003, there is a bug that can cause this behavior. And there is a hotfix for it. Check Allen Browne's site http://allenbrowne.com/bug-Access2003SP3.html You might check the properties of the combobox and make sure the column count is equal to the number of columns being passed by the source. I have found that sometimes this works to fix the problem. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County CDS wrote: I am new to Access and have Vista 64 with Access 2007 and XP with 2003. I created a database in the 2007 ver as a 2002-2003 and when I opened it in 2003 there were no error messages but a major combo box drop down is blank. I went back to the 2007 ver with the same file and it opened fine. There are appox. 80 small records in the Lookup Table that is not showing. Any ideas? Thanks. |
Thread Tools | |
Display Modes | |
|
|