I have a "make table query" that has check boxes in the table, that when you update the query, it changes the properties of the check box to text box. The data fields come out -1 and 0 instead of a check box. Anyone have an idea how I can get the property of the check box to stay the same when I update the query? Thanks a bunch!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Mahe Table Query
- Thread starter mattpv
- Start date
Go into design view of the new table, select the field with Yes/No data type. In the properties click on the Lookup tab, from the Display Control, which current states "Text", click the black drop down arrow and select "Check Box"
- Status
Similar threads
- Question
- Locked
- Question