[Solved] Check box

Creating tables and queries

[Solved] Check box

Postby loudog » Sun Feb 03, 2008 6:11 am

I have learned much from the tutorials :) but have not seen the application of check boxes covered. What type of data input selection (Varchar etc.) would i use for a checkbox field :?:

loudog
Last edited by Hagar Delest on Tue Jun 10, 2008 2:56 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
loudog
 
Posts: 13
Joined: Thu Jan 31, 2008 11:13 pm

Re: check box

Postby DrewJensen » Sun Feb 03, 2008 6:29 am

You can use a checkbox control on a form for columns with datatypes of
Yes/No ( Bolean )
Text( fixed )
Text( varchar )
Numeric

In all cases other then Boolean Checked = 1 and unCheched = 0
For an embedded database Checked = TRUE ( Yes ) and unChecked = FALSE ( No )
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
User avatar
DrewJensen
Volunteer
 
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: check box

Postby loudog » Sun Feb 03, 2008 6:51 am

Nicely covered :D . Thank you ;)

loudog
loudog
 
Posts: 13
Joined: Thu Jan 31, 2008 11:13 pm


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 3 guests