Combo Box Error - no displaying data

[IT-1957]

Hi every one, I have a combo box that looks up data in a form, I have 3
columns:
ID, WEEK ,ORDER
When I set up the combo to look for the firts column, ID it works fine but
when I try to look up the Order it doesn't show anything. It looks like is
there, I can actually scroll down to the "list" but I can not see or select
anything.
The code the the wizard creates is:

Private Sub Combo26_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ID] = " & Str(Nz(Me![Combo26], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

What actaully changes between them is the formating of the visible colums on
the property of the combo box itself....
Now The form works fine on another computer but it does not work on my.
I already check for Updates and there are not more available.
Do I need to reinstall Office or there is a solutions for this?

Thank you for your help.

 

[Linq Adams via AccessMonster.com]

Unfortunately, it sounds like you're running Access 2003 and 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 "disappearing" 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

 

[IT-1957]

Thank you !
The hot fix fixed the problem.