Problem with Office 2003 SP3 in Access 2003

B

Brossyg

In Access 2003, I have a Combo box in a form with one of the columns
formatted Yes/No (the table the data comes from is also yes/no data). When
the Combo Box was dropped-down, the column correctly showed "Yes" or
"No"...until I installed Office 2003 SP3. Now, the column shows "-1" or "0"
now matter that the format property is set to "Yes/No".

Has anyone else experienced this and found a solution?

Brossyg
 
T

TaurArian [MS-MVP]

Some of the changes in Service Pack 3 modify the behavior of Office 2003, including
changes that disable some features by default and increase control for computer
administrators. Changes include:
a.. Office 2003 can no longer open or save certain file formats. For more information,
see Microsoft Knowledge Base Article 938810.
b.. MAPI forms do not run in public folders and user folders. For more information, see
Microsoft Knowledge Base Article 938816.
c.. Office 2003 can now be configured to allow or deny specific COM components. For more
information, see Microsoft Knowledge Base Article 938815.
d.. Some COM components with unusual characteristics may not function as expected. For
more information, see Microsoft Knowledge Base Article 938814.
e.. Changes have been made to the behavior of Microsoft Office Document Imaging. For
more information, see Microsoft Knowledge Base Article 938813.
f.. Attachments with the .gadget extension can no longer be opened in Outlook. For more
information, see Microsoft Knowledge Base Article 938811.
g.. Access add-ins can no longer be configured for use by all users. For more
information, see Microsoft Knowledge Base Article 938809.
h.. The Fast Save setting in Microsoft Office Word has been removed. For more
information, see Microsoft Knowledge Base Article 938808.
i.. Documents saved in certain formats no longer contain the version number of Office.
For more information, see Microsoft Knowledge Base Article 938807.
j.. Certain macros in older Excel file formats have increased security. For more
information, see Microsoft Knowledge Base Article 938806.

--
====================================
TaurArian [MS-MVP] 2005-2008 - Australia
====================================
How to make a good post: http://www.dts-l.org/goodpost.htm
Defending your machine: http://defendingyourmachine2.blogspot.com/
http://taurarian.mvps.org/index.htm

Emails will not be acknowledged - please post to the newsgroup so all may benefit.


| In Access 2003, I have a Combo box in a form with one of the columns
| formatted Yes/No (the table the data comes from is also yes/no data). When
| the Combo Box was dropped-down, the column correctly showed "Yes" or
| "No"...until I installed Office 2003 SP3. Now, the column shows "-1" or "0"
| now matter that the format property is set to "Yes/No".
|
| Has anyone else experienced this and found a solution?
|
| Brossyg
 
B

Brossyg

I appreciate your effort in responding, but this does not help. Access
allows a "Yes/NO" text format to appear in a combo box and SP3 interferes
with that. SP3 is broken because it takes away primary formatting
functionality in Access. Please use your MVP status and have them fix SP3.

TaurArian said:
Some of the changes in Service Pack 3 modify the behavior of Office 2003, including
changes that disable some features by default and increase control for computer
administrators. Changes include:
a.. Office 2003 can no longer open or save certain file formats. For more information,
see Microsoft Knowledge Base Article 938810.
b.. MAPI forms do not run in public folders and user folders. For more information, see
Microsoft Knowledge Base Article 938816.
c.. Office 2003 can now be configured to allow or deny specific COM components. For more
information, see Microsoft Knowledge Base Article 938815.
d.. Some COM components with unusual characteristics may not function as expected. For
more information, see Microsoft Knowledge Base Article 938814.
e.. Changes have been made to the behavior of Microsoft Office Document Imaging. For
more information, see Microsoft Knowledge Base Article 938813.
f.. Attachments with the .gadget extension can no longer be opened in Outlook. For more
information, see Microsoft Knowledge Base Article 938811.
g.. Access add-ins can no longer be configured for use by all users. For more
information, see Microsoft Knowledge Base Article 938809.
h.. The Fast Save setting in Microsoft Office Word has been removed. For more
information, see Microsoft Knowledge Base Article 938808.
i.. Documents saved in certain formats no longer contain the version number of Office.
For more information, see Microsoft Knowledge Base Article 938807.
j.. Certain macros in older Excel file formats have increased security. For more
information, see Microsoft Knowledge Base Article 938806.

--
====================================
TaurArian [MS-MVP] 2005-2008 - Australia
====================================
How to make a good post: http://www.dts-l.org/goodpost.htm
Defending your machine: http://defendingyourmachine2.blogspot.com/
http://taurarian.mvps.org/index.htm

Emails will not be acknowledged - please post to the newsgroup so all may benefit.


| In Access 2003, I have a Combo box in a form with one of the columns
| formatted Yes/No (the table the data comes from is also yes/no data). When
| the Combo Box was dropped-down, the column correctly showed "Yes" or
| "No"...until I installed Office 2003 SP3. Now, the column shows "-1" or "0"
| now matter that the format property is set to "Yes/No".
|
| Has anyone else experienced this and found a solution?
|
| Brossyg
 
M

Milly Staples [MVP - Outlook]

I am afraid you greatly overestimate the influence that MVPs have with
Microsoft.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Brossyg wrote:

| I appreciate your effort in responding, but this does not help.
| Access allows a "Yes/NO" text format to appear in a combo box and SP3
| interferes with that. SP3 is broken because it takes away primary
| formatting functionality in Access. Please use your MVP status and
| have them fix SP3.
|
| "TaurArian [MS-MVP]" wrote:
|
|| Some of the changes in Service Pack 3 modify the behavior of Office
|| 2003, including changes that disable some features by default and
|| increase control for computer administrators. Changes include:
|| a.. Office 2003 can no longer open or save certain file formats.
|| For more information, see Microsoft Knowledge Base Article 938810.
|| b.. MAPI forms do not run in public folders and user folders. For
|| more information, see Microsoft Knowledge Base Article 938816.
|| c.. Office 2003 can now be configured to allow or deny specific
|| COM components. For more information, see Microsoft Knowledge Base
|| Article 938815. d.. Some COM components with unusual
|| characteristics may not function as expected. For more information,
|| see Microsoft Knowledge Base Article 938814. e.. Changes have been
|| made to the behavior of Microsoft Office Document Imaging. For
|| more information, see Microsoft Knowledge Base Article 938813.
|| f.. Attachments with the .gadget extension can no longer be opened
|| in Outlook. For more information, see Microsoft Knowledge Base
|| Article 938811. g.. Access add-ins can no longer be configured for
|| use by all users. For more information, see Microsoft Knowledge Base
|| Article 938809. h.. The Fast Save setting in Microsoft Office Word
|| has been removed. For more information, see Microsoft Knowledge Base
|| Article 938808. i.. Documents saved in certain formats no longer
|| contain the version number of Office. For more information, see
|| Microsoft Knowledge Base Article 938807. j.. Certain macros in
|| older Excel file formats have increased security. For more
|| information, see Microsoft Knowledge Base Article 938806.
||
|| --
|| ====================================
|| TaurArian [MS-MVP] 2005-2008 - Australia
|| ====================================
|| How to make a good post: http://www.dts-l.org/goodpost.htm
|| Defending your machine: http://defendingyourmachine2.blogspot.com/
|| http://taurarian.mvps.org/index.htm
||
|| Emails will not be acknowledged - please post to the newsgroup so
|| all may benefit.
||
||
|| ||| In Access 2003, I have a Combo box in a form with one of the columns
||| formatted Yes/No (the table the data comes from is also yes/no
||| data). When the Combo Box was dropped-down, the column correctly
||| showed "Yes" or "No"...until I installed Office 2003 SP3. Now, the
||| column shows "-1" or "0" now matter that the format property is set
||| to "Yes/No".
|||
||| Has anyone else experienced this and found a solution?
|||
||| Brossyg
 
E

EW

See yours below...

To me, a casual home Office 2003 user, it seems like SP-3 is a step
backwards, except for security improvements, possibly. After reading
several postings about the SP, I think I'm going to give it a pass. I hope
I'm not making a mistake but my setup (SP-2) works perfectly, and I doubt
SP-3 would improve it. Comments -- I need all the help I can get!!

EW
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top