Access 2003 SP3

[Wanz]

In Access 2003, I have a Combo Box in a form. It works fine with Office 2003
SP2. However after I installed the Office 2003 SP3, each time I click the
Combo Box the dropped-down it shows "Blank" data ... Appreciate if someone
could assist me on this matter

 

[John W. Vinson]

In Access 2003, I have a Combo Box in a form. It works fine with Office 2003
SP2. However after I installed the Office 2003 SP3, each time I click the
Combo Box the dropped-down it shows "Blank" data ... Appreciate if someone
could assist me on this matter

There is a BUG - actually several! - in SP3. This is one of them!

You'll need to remove any Format property on any of the fields included in the
combo box. Can't guarantee that it will help, but that's the first thing to
try.

I just had a client who had to completely uninstall Office and reinstall up to
SP2, due to a much worse problem (bogus memory overflow errors on opening any
form in design view).

John W. Vinson [MVP]

 

[Wanz]

Thanks for the prompt respond ... After removing the Format property i.e ">"
in the field ... the combo box works as usual . I used the ">" format to
convert all lower case letter to upper case. Since this is a bug issue in SP3
I hope Microsoft will do something.

 

[paradigm]

I had a similar problem. It was caused by the query for a combo box
returning too many fields and giving odd memory errors and crashing whenever
a form was opening in design view. Was working fine in an earlier version of
Access.
Alex

 

[John W. Vinson]

Thanks for the prompt respond ... After removing the Format property i.e ">"
in the field ... the combo box works as usual . I used the ">" format to
convert all lower case letter to upper case. Since this is a bug issue in SP3
I hope Microsoft will do something.

Just note that the > format does *NOT* convert anything at all. It simply
displays lowercase letters as uppercase; the table still contains the letters
as entered.

John W. Vinson [MVP]

 

[Tony Toews [MVP]]

I had a similar problem. It was caused by the query for a combo box
returning too many fields and giving odd memory errors and crashing whenever
a form was opening in design view. Was working fine in an earlier version of
Access.

I have some code I wrote yesterday that I will be making available in
a day or two to go through your MDB looking for all such combo boxes.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/