Boolean values for Checkbox fields

  • Thread starter cmonroe21 via OfficeKB.com
  • Start date
C

cmonroe21 via OfficeKB.com

I have a few checkboxes in my custom Outlook 2007 form. When I change the
"View" of my calendar to "All Appointments" and choose which fields I would
like to show (so that I can see an Outlook spreadsheet and copy/paste the
data to an Excel spreadsheet and report against the fields extracted), I can
get all the fields to show up (including the color categories, textboxes,
comboboxes and checkboxes)... but when I copy (Ctrl Shift DownArrow) and
paste into Excel, the checkboxes don't show up at all. All the other fields,
including the color categories, show up, but it's like Excel doesn't
recognize the checkboxes.

In the Outlook spreadsheet the status of the checkbox is marked as an icon of
an empty checkbox or a checked checkbox in the actual cell, not a y/n...
maybe it's the picture of the checked or not-checked checkboxes that Excel
doesn't recognize? Maybe if I could get them to show up as Y/N or O/I or T/F
instead of as little icons Excel would recognize them and import them? In
the Properites tab where I created the field I assumed that the "format" of
the field would have to be Yes/No (as apposed to text or number, etc.), but I
tried to use different "property to use" choices (used all 4 offered: icon,
Yes/No, True/False and On/Off), but they all kept showing up in the Outlook
spreadsheet as little checked or unchecked checkbox icons in the cells and
would not show up in Excel when I copy and pasted the data.

Any suggestions? I just need to be able to pull a boolean value from these
checkboxes (yes/no) that takes to Excel. (or a better way than Excel to
extract the data and create a report?)

Thank you!!
 
C

cmonroe21 via OfficeKB.com

I right clicked in the headers and selected format columns :) Let's see if
that works.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top