Yes/No checkbox is no longer a checkbox

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.

Thanks,

--
Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200805/1

.

Relevant Pages

  • 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 ...
    (microsoft.public.dotnet.languages.vb)
  • 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 ...
    (microsoft.public.access.forms)
  • 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. ...
    (microsoft.public.access.formscoding)
  • 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 ...
    (microsoft.public.access.queries)
  • 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. ...
    (microsoft.public.access.formscoding)