Combo Box stopped working after installing SP3 in Access 2003

  • Thread starter Thread starter hank1234
  • Start date Start date
This is one of the many bugs in SP3! The fields that don't show have
something in their format property. The ususal culprit is > which forces
UpperCase. Simply remove any formatting to these fields and everything should
be OK!

Other alternative is to uninstall Access then re-install thru SP2!

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

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
 
Linq Adams via AccessMonster.com said:
This is one of the many bugs in SP3! The fields that don't show have
something in their format property. The ususal culprit is > which forces
UpperCase. Simply remove any formatting to these fields and everything should
be OK!

Other alternative is to uninstall Access then re-install thru SP2!

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

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com


You're right - formatting was the problem. But I had to remove ALL formatting on the underlying table (to the control's query source) before the field once more showed up.
Click to expand...
Thanks for the help,
hank1234
 
Linq said:
This is one of the many bugs in SP3! The fields that don't show have
something in their format property. The ususal culprit is > which forces
UpperCase. Simply remove any formatting to these fields and everything should
be OK!

Other alternative is to uninstall Access then re-install thru SP2!
Click to expand...

Thanks for the inside info; I had the exact same problem and ended up going
back to Acess and SP2. Do you know of any other bugs to Access 2003 after
the update or am I better off sticking with SP2?
 
After installing SP3 update, multi_column combo boxes now only show the last
column.
Click to expand...

I have had the same problem, i resolved it with removing any
expression in table Design view from Field Format Properties
section .

By
exfonderia
 
Back
Top