Checkbox issue

posfog

Board Regular
Joined
Jun 2, 2009
Messages
171
Hi All,
This may be easy for some but I have looked around and can't see an answer to my issue.

I have created a form with a number of checkboxes and when I pull the data from access into excel in a table format all the details from the check boxes show ether False or True.

Is there anyway that a check box can display 0 for false and 1 for true

Kind Regards as always

P
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
How are you pulling the date into Excel?
 
Upvote 0
How are you pulling the date into Excel?
Hi
I am not sure if the correct term but I am going to the data tab in XL and clicked on from access in the top left and corner to allow me to get external data selecting the axis file for the data source.
I then choose table and put the data in the worksheet
I hope this makes sense
 
Upvote 0
maybe the Access table field is formatted as Yes/No? Not sure if Excel would still do the same if it was True/False. Would probably not if it was integer, which is really the best choice for TRUE/FALSE, YES/NO, ON/OFF regardless. Can the spreadsheet column format not be modified so suit?
EDIT - in Access 0 is false, -1 is True. In expressions and vba, anything other than 0 will be treated as True.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,947
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top