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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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,497
Messages
6,113,998
Members
448,541
Latest member
iparraguirre89

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