Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Office SP3 Listbox bug

Status
Not open for further replies.

NSNewey

Programmer
Jun 29, 2005
125
GB
Hi,

I have just installed Office 2003 service pack 3 update.
Now all my yes/no fields in access listboxes have changed to 0/-1 format.

Has anyone got a fix for this. I don't want to change the underlying query to format the boolean field as I have several databases with many lists.

I am guessing that I will have to uninstall SP3.
 
Haven't seen the error but what about using the MDBsearch add in to find and replace the yes/no entries in your db?
 
We have pushed Office 2003 SP3 to our users, and all of them have this same issue... I had to uninstall Office and reinstall back to SP2.

Also, we found that the SP3 changed the format of fields with currency $000.00 to a regualar decimal 000.0000 format.

Anyone else heard of these issues?
 
Just installed Office 2003 SP3 but luckily only on one of our computers- mine! Have both the Currency format problem and the Yes/No plus have read on other groups that some have fields that don't show in list boxes.

Looks as if I am going to unstall Office 2003 and then reinstall but not SP3 as I don't have time to try and rework all the combos and lists I have going.

Guess I should have checked here before updating.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top