|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Importing Access checkboxes to Excel
My problem is this: I have an Access database with several fields are checkboxes, for a true/false value. However, when I export the main table to an Excel spreadsheet, the checkboxes don't come along for the ride. The cells instead have the word TRUE in the cell if the box was checked, and FALSE if the box was not checked. When I select one of the cells, I expected to see a function, but I just see text TRUE or FALSE.
Is there a way to replace these TRUE/FALSE text values with checkboxes, en masse, in one simple step? Thanks! Peter |
|
#2
|
||||
|
||||
|
The only way I could think of doing this would be to write a visual basic macro that would go through and replace it with the check boxes.
You would just have a loop that checks the value of the field, adds a checkbox and then ticks it if the field is true. |
|
#3
|
|||
|
|||
|
Thanks A.Koepke
Thanks. I'll try it.
|
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > Importing Access checkboxes to Excel |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|