Boolean values for Checkbox fields

Status
Not open for further replies.
C

cmonroe21

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!!


200903
 
C

cmonroe21

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

that works.

cmonroe21 wrote:
> 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!!


 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
A help please -Boolean - can I use .AND NOT etc in a rule Exchange Server Administration 0
O Comma Separated Values.ADR and A file error has occurred in the translator Using Outlook 5
A Add attachments to appointment based on field values Outlook VBA and Custom Forms 0
Diane Poremsky Could not complete the operation. One or more parameter values are not valid. Using Outlook 0
T What code to use to move the custom field values to message body when sending e-mail ? Outlook VBA and Custom Forms 8
N How to retrieve user defined fields values to bcm form. Using Outlook 2
D Multiple values for a field (like categories) Outlook VBA and Custom Forms 1
M Make 2 independent Subs use shared Data Values Using Outlook 3
S Populate textbox values from one form to another form. Using Outlook 0
M Default values for contacts Using Outlook 8
G Displaying value of task subject field as values from two custom fields Using Outlook 4
W Linking dropdown values Outlook VBA and Custom Forms 1
B Passing values from custom form into another form's text box Outlook VBA and Custom Forms 1
M Assigning Values to Contact UserProperties Outlook VBA and Custom Forms 1
J User defined fields with pre-defined values Outlook VBA and Custom Forms 3
J Getting values of custom categories set on Calendar folder Outlook VBA and Custom Forms 2
E Where is the best place to store values for combobox entries Outlook VBA and Custom Forms 5
E Where is the best place to store values for combobox entries Outlook VBA and Custom Forms 5
H Error in values when exporting report to Excel BCM (Business Contact Manager) 1
V Why is "Value Required" checkbox greyed out for Dates? Outlook VBA and Custom Forms 2
J Program Checkbox that will activate a text box in a Outlook fallible form. Outlook VBA and Custom Forms 1
A Greyed out checkbox in custom form Outlook VBA and Custom Forms 4
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
Stephen Weinberg Changing the mailing address checkbox Using Outlook 0
S Open custom meeting request with checkbox Using Outlook 0
S Outlook custom checkbox not changing value Using Outlook 0
S Dynamically add recipients using combobox and checkbox????? Using Outlook 2
F Checkbox Private Outlook VBA and Custom Forms 2
T Ribbon and a checkbox (C++ ATL) Outlook VBA and Custom Forms 8
J Checkbox Outlook VBA and Custom Forms 1

Similar threads

Top