After installing SP3 update, multi_column combo boxes now only show the last
column.

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
http://www.accessmonster.com/Uwe/For...oding/200711/1

"Linq Adams via AccessMonster.com" wrote:

> 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
> http://www.accessmonster.com/Uwe/For...oding/200711/1
>
> 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.
Thanks for the help,
hank1234

Linq Adams wrote:
>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!
>

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?

--
Message posted via http://www.accessmonster.com

On Nov 26, 10:21 pm, hank1234 <hank1...@discussions.microsoft.com>
wrote:
> After installing SP3 update, multi_column combo boxes now only show the last
> column.

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

By
exfonderia