Is this a bug?? (Combo box problem...)

[Guest]

I went to use my find an employee drop down the other day and low and behold
I couldn't see any of the employee names in the drop down list. It was also
giving me an error. So I went into the database to fix the error - for some
reason, out of the blue, it wanted to give the combo box a different name
Combo95 instead of Combo165 or whatever which caused it to not want to work.
Okay, so I thought it was solved.

So no more error message, but still cannot see any of the names in the drop
down list. This is a simple combo box made from a wizard (find a record in my
form based on the value I selected in my combo box...). They are there,
because if I scroll down and click, the person's record shows up. Anyone else
have this problem or know what this is? (I'm on Access 2003 but my DB is
still 2000 I believe).

Very frustrated! Cannot recreate this dropdown! :-(
Tanya

 

[Ken Snell \(MVP\)]

By chance, the field to which the combo box is bound is a text field and has
a Format property setting for the field in the table? If yes, this is a bug
that has been reported by many ACCESS users during past weeks. It apparently
is a bug in Office 2003 SP3, which was released by MS about a week ago. MS
is aware of the bug and is working on how to fix it.

In the meantime, the "complete workaround" is to remove the Format
property's value from the field's properties in the table's design view.
Otherwise, concatenating the field's value with an empty string also seems
to "overcome" the problem.

 

[Guest]

Thank you for your reply. I talked to our IT Department, and they did install
SP3 just around the time I found this error.

 

[John W. Vinson]

I went to use my find an employee drop down the other day and low and behold
I couldn't see any of the employee names in the drop down list. It was also
giving me an error. So I went into the database to fix the error - for some
reason, out of the blue, it wanted to give the combo box a different name
Combo95 instead of Combo165 or whatever which caused it to not want to work.
Okay, so I thought it was solved.

So no more error message, but still cannot see any of the names in the drop
down list. This is a simple combo box made from a wizard (find a record in my
form based on the value I selected in my combo box...). They are there,
because if I scroll down and click, the person's record shows up. Anyone else
have this problem or know what this is? (I'm on Access 2003 but my DB is
still 2000 I believe).

Very frustrated! Cannot recreate this dropdown! :-(
Tanya

There is in fact a bug introduced with A2003 Service Pack 3 (which probably
got installed automatically, and which *cannot* be uninstalled other than by
removing Access from your computer altogether and reinstalling up to SP2).

The getaround is to remove *all* formats on all fields in the combo box's
rowsource, including >.

John W. Vinson [MVP]

 

[Guest]

So what if a person does this, and it still doesn't fix the issue?

I've got an employee with a similar drop-down field problem, and I've got a
copy of the database. I went through and removed all formatting in the form
and in the table, saved both, but still have this same issue.

Any other ideas for a work around?