Change behavior of true from -1 to 1

[fdlane]

I have an Access FrontEnd to an existing Oracle application. The
Oracle app has some flag fields that expects 1/0 for true/false not -1
for true.

Is there a way to have VBA and controls like chkBoxes to treat 'True'
as 1 instead of -1?

I can write around the behavior of Access, but thought maybe there was
a trick to change the default for true.

TIA,

DeWayne

 

[Van T. Dinh]

Access (and most other database engines) will treat 0 as False and non-zero
values as True so the CheckBox Controls will handle this automatically for
you anyway.

In fact, in MS SQL Server, we use 1/0 for True/False also. It creates some
quirky behaviours but we learn to live with it.

 

[fdlane]

Thanks for the response.

The existing Oracle app is testing for a 1 and not <> 0 in the flag
fields. My Access portion has to comply with this. I'll just code
around it.

Thanks again.

DeWayne