Yes/No Data Type

[ParkerWrecker]

I used the visual data mgr to build my dbase (access). If im not mistaken this VDM uses an old version of MSAccess, is there a way that i can use a Yes/No data type that i can assign to one of my fields (checkbox on my form?)?

Help please....

 

[MarkSweetland]

VB Checkbox values are:
vbUnChecked = 0
vbChecked = 1
vbGrayed = 2

Access Yes/No values:
Yes = -1
No = 0

So, I guess you could take the absolute value [abs()] of the field to mark either checked or unchecked.






Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach