Combo currency yes/no display

[CDev]

I have developed numerous apps in Access 2003. Recently all my combo boxes
that have yes/no or currency fields now display -1/0 instead of yes/no and
general number format rather than currency.

If anyone can explain why this suddenly changed (possibly from windows xp
update or MS Access update), I would greatly appreciate it.

 

[Allen Browne]

Could the problem have resulted from recently applying SP3 for Office 2003?

There were some bugs relating to the Format property of fields messing up
combos in this SP.

Microsoft released a hotfix for some of the issues it introduced. Can't
promise it will fix this one, but if you want to investigate:
http://support.microsoft.com/kb/945674

Other info:
http://allenbrowne.com/bug-Access2003SP3.html

 

[CDev]

Thank you very much Allen. You were exactly right. Installing the hotfix
resolved my issues.

However, this now brings up other issues for me as an Access 2003 developer
who distributes 2003 runtime apps using MS Office Developer Exentions. It
would seem that I now need to notify every one of my customers and direct
them to run the hot fix also.

Furthermore, as a registered Access and Developer Extensions licensee, I
feel I should have been notified of this issue. This whole issue is quite
upsetting to me.

I would greatly appreciate it if MS could make the hotfix a little easier by
not prompting the user for the location to store the files. Some customers
can be PC challenged and it would save a fair bit of tech support time if the
user did not have to interact with the update.

Thanks for sharing your knowledge and assisting, Allen.