Prev: Filtering Records in Statement Opening Form
Next: Like "MU*" OR Like "MS*"
From: Mouimet on 3 Jul 2008 12:39
HI, I create a database in Office XP and every drop down menu was working
well since 2005. IT upgrade our Office 2003 and now in all database, all drop
down menu do not work anymore. When we click on it we dont see any choices.
However if try to select something even if we see nothing, the right name
appear and all others field is showed perfectly. If I open the same database
with another computer not updated the drop down menu work fine. Can somebody
can help on this? I have 4 databases with the same problem. Thank you
From: Linq Adams via AccessMonster.com on 3 Jul 2008 12:57
Unfortunately, you've apparently updated to the SP3 service pack and it's
buggier than the Great Dismal Swamp! One of the most common bug reported
involves comboboxes with disappearing data! The field(s) in the cbo, in the
underlying table, have some kind of formatting in place. This is often the
simple > used to force UpperCase. Remove any formatting from the fields and
things should work short term, but the definitive solution is to install the
hotfix for SP3.

Here's a link to Allen Browne's site where you can find the latest news about
these bugs, as well a link to the Hotfix:

http://allenbrowne.com/bug-Access2003SP3.html

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200807/1

 | 
Pages: 1
Prev: Filtering Records in Statement Opening Form
Next: Like "MU*" OR Like "MS*"