By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,466 Members | 1,141 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,466 IT Pros & Developers. It's quick & easy.

Export to Excel issue

P: 11
I'm a novice user of Access, maybe an intermediate on a good day and I've been building a database for my particular job. The database itself is complete, and I am now building the reports that I'll need to report my data to the higher ups.

The form I'm using to input the data has a series of checkboxes for the products and services my company provides.

Whenever I try to export any reports that show the results of these check boxes it doesn't populate in Excel. It is simply blank, however every other poplated field, Customer Name, Agent name etc populates fine and exports correctly.

If anyone could give me an idea of what I'm doing wrong I would appreciate it greatly.


Feb 12 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 108

It seems that you've got a better handle on things than you think. What you are running into is the fact that most fields carry a value, whereas a checkbox while it has a value is more of a state. For instance a text box may contain "Bob" for it's entered value and therefor will export "Bob" to a cell. However, a checkbox is a state indicator and therefor may have issues exporting its value.

Without seeing you code I can only guess at the route you will need to take, but it should get you moving. What you will need to do is export the text value of checkbox as it is currently exporting the numeric or similar. To do this you can wrap the section of the export code for those fields in an If statement that will convert the value to text such as "Yes" or "No".

If you have any troubles with this please include the code you are using so we can give you a more specific answer.

Hope this helps.

- Minion -
Feb 12 '08 #2

P: 11
Thank you so much! It turned out to be the simplest thing in the world, but the issue is fixed now. Thank you for your help, everyone here is so helpful and friendly!

Mar 3 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.