Re: How do you create a checkbox in a column?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Wayne Morgan (comprev_gothroughthenewsgroup_at_hotmail.com)
Date: 01/31/05 

Date: Mon, 31 Jan 2005 08:56:21 -0600

First, the order of the columns in the table shouldn't matter as far as data
entry goes because you shouldn't be entering the data directly into the
tables. Design a form for data entry. Place the controls on the form where
you desire and set their tab order to move between them in the order
desired.

Next, a checkbox is a True/False or Yes/No field. Access stores True as -1
and False as 0. 

-- 
Wayne Morgan
MS Access MVP
"NYLibertyfan" <NYLibertyfan@discussions.microsoft.com> wrote in message 
news:8EECD1BB-9688-4D07-BEFC-1C8930D4B17D@microsoft.com...
>I have been tasked to "refresh" an existing database, where we track 
>proposal
> activity, and I have no Access experience whatsoever.  My goal is to
> rearrange the information to sequentially match how we currently work on
> proposals.  For instance, I don't need the "Award Date Column" to be the
> third column in the table.  It's too early to reflect that information. 
> It
> should be near the end.
>
> With that in mind, some colums are text and there are a few columns that
> consist of checkboxes.  In rearranging the columns with checkboxes, I 
> thought
> it would be as simple as doing the old copy/paste method.  However, when I
> paste, I have numbers instead of checkboxes.
>
> So, since it's apparent that I can't move the checkboxes using the
> copy/paste method, how do I create a column with checkboxes?

Relevant Pages

  • How do you create a checkbox in a column?
    ... and I have no Access experience whatsoever. ... rearrange the information to sequentially match how we currently work on ... In rearranging the columns with checkboxes, ... it would be as simple as doing the old copy/paste method. ...
    (microsoft.public.access.gettingstarted)
  • Re: How do you create a checkbox in a column?
    ... > rearrange the information to sequentially match how we currently work on ... > proposals. ... In rearranging the columns with checkboxes, ... > it would be as simple as doing the old copy/paste method. ...
    (microsoft.public.access.gettingstarted)
  • Re: Making check boxes active on selection of radio button...
    ... > Hi yall ... > I have a form for entry to an event ... Hi Mark, I can help you on this as I am a bit of an expert in ... Make the 5 and all its checkboxes an image with greyed out ...
    (alt.html)
  • Re: Dcount Month Help
    ... If this were mine, I'd create a query to count the checkboxes ... Microsoft Office/Access MVP ... I have a table which conatains DATE of Entry and Tick Box. ... DCOUNT those tick boxes which are yes for the month of January from the ...
    (microsoft.public.access.forms)
  • Re: listView question
    ... Is it possible to have a listview with checkboxes that allows the user ... and vice-versa ie check a box without selecting that entry. ... sure if there is one) ie if both called then call the checkedbox event ...
    (microsoft.public.dotnet.languages.csharp)