Yes/No checkbox is no longer a checkbox
- From: "ragtopcaddy via AccessMonster.com" <u9289@uwe>
- Date: Wed, 28 May 2008 13:55:40 GMT
I recently split my mdb for front and back end.
One of the tables has a boolean field that displays as a checkbox. The linked
table displays the checkbox. When I do a maketable query on the linked table,
the resulting table no long has a checkbox, but 0's and -1's. There doesn't
seem to be any way to format it to display the checkbox. Of course, I will
just import the table from the BE, but I'm just curious as to why they
weren't checkboxes to begin with, and furthermore, why I can't change them
back to checkboxes.
"If you can't laugh at yourself, laugh at somebody else"
Message posted via AccessMonster.com
- Re: How to Add *AND* Process Checkbox Column in a DataGridView?
... DataGridViewCheckBoxCell. ... A value of Null or False will leave the checkbox unchecked. ... Add a cb to the dgv, iterate thru the dgv and update the bound ... Create an alias boolean field in the SELECT statement when creating ...
- Re: Can I make a checkbox do this?
... and add a Boolean field "Show". ... I set the control source for chkSelected to: ... > Private Sub chkSelectItem_MouseUp(Button As Integer, Shift As Integer, X As ... > Which does work as I want, the record is updated and the checkbox control ...
- Re: checkbox mania...
... A check box can only hold the values true or false (Boolean) ... values of the boolean field in your records and hence the bound check box on ... > for each checkbox in the collection. ... >>> collection with the recordid I have in another field. ...
- Re: Filtering Checkboxes
... If a field is defined as a boolean field then it ... It is always Zero or -1. ... A checkbox value is Null until it is set; ... I have a query were I need to filter either all the boxes that are ...
- Re: Question about Sub Form Coding
... Sounds like your checkbox is "unbound"... ... Add a boolean field (ex. ... Lock) to your subform table, include it in the query behind ... and set your checkbox ControlSource to Lock. ...