With the introduction of the Boolean data type in VB4, you might be tempted to convert it to a numeric value using the Val function for storage in a database table. Watch out! Val won’t convert a Boolean into -1 (or 1) as you might expect. Use the Abs or CInt functions, depending on the format you need:
Val(True) gives 0 CInt(True) gives -1Abs(True) gives 1