SP3 changes Combo Yes/No dropdown to -1/0 ?

[Jim]

Hi ...
I haven't used Access that much, but received the following problem from a
user and wonder if the Office SP3 may have caused this... he has a form which
uses a combo box to display some data from a table... it used to be that a
logical field would display as "yes" or "no". Seemingly after the SP was
installed, the drop down now shows the users "-1" or "0". Could this
behavior change be caused by the service pack? Is there any way to go back
to the "yes"/"no" display? (Again, I don't know much about Access or Office
forms, since I've mainly kept to .NET/Oracle stuff.

Thanks for any help...
Jim



The update to Office with Service Pack 3 and/or one of the other changes
installed today has affected MS Access in various Forms I use in the MRule
Database.

I have Forms which use a Combo Box to show a drop down list of certain data
from a table in the database. After today's update the Yes/No fields in the
dropdown now display as either "-1" or "0" rather than "Yes" or "No". I have
verified, on a non-updated laptop, that the Form dropdown displays Yes/No
just to make sure there was not something different in the Table itself.

 

[Tom van Stiphout]

On Tue, 11 Dec 2007 15:28:00 -0800, Jim <[email protected]>
wrote:

Yes/No, -1/0, True/False are all the same thing to Access. If you want
to display "Yes"/"No", I might suggest creating a 2-column dropdown
with -1,0 as the hidden column(0), and "Yes", "No" as the visible
column(1). The control wizard can help you with this. The bound column
number would be 0.

I'm not sure why MSFT would have changed this behavior for SP3, but we
have received similar reports here.

-Tom.