DoCmd.SendObject acSendReport checkBoxes are not shown

Dear Experts,
I met a very strange problem. I use the code:
DoCmd.SendObject acSendReport ... to send a report to my email box, but the check boxes on the report do not show on the received report. the format i have tried: acFormatRTF, acFormatHTML, acFormatSNP
Could anyone please help me out?
lzha022
lzha022Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rockmuncherConnect With a Mentor Commented:
RTF drawing objects (eg. lines, circles, boxes, etc.) cannot be exported from Access.  This included checkboxes.
You need to alter your report's recordsource so that it returns (say) 'Yes' or 'No', and put that value into a textbox instead of using a checkbox.
0
 
shanesuebsahakarnCommented:
Do they show if you print or preview the report?
0
 
shanesuebsahakarnCommented:
They should show up in snapshot format though (which the questioner did say he'd tried).
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
rockmuncherCommented:
Could it be that outlook is set up to edit/display in plain text only?

In outlook, Tools-Options-MailFormat tab-Compose in this format

options are Rich Text, HTML, and plain text.  Change to Rich Text
0
 
lzha022Author Commented:
The original report is perfect, only the received report. The checkboxes do not show when i print it out. I really want checkboxes to be shown(i do not want to change it to text). When i tried the snapshot format. i could not open the received file. It asked me to install some windows software(i do not have the right to install anything on my computer). I followed rocknumcher`s steps to chnage the setting of outlook, but i could not find MailFormat tab under Tools-Options. I did find Compose under Options, which looks a bit different.

Thanks for all reply
lzha022
0
 
shanesuebsahakarnCommented:
If the checkboxes don't show when you print it out either, there is something wrong with your report, in that case. If they do show up on print, Snapshot format will show them, but you need Snapshot Viewer to see the output.
0
 
rockmuncherCommented:
If worse comes to worse you can print out checkboxes from the WingDings font using the same methodology as the Yes/No suggestion above, but I think it would be better to try and sort out why the report isn't printing properly.

0
 
lzha022Author Commented:
I think you all know that the report that is not printing properly is the received one in the form of RTF.
0
 
shanesuebsahakarnCommented:
Follow rockmuncher's instructions on changing the checkboxes to text or combo boxes.
0
 
lzha022Author Commented:
So there is no way to show those check boxes on the RTF report?
0
 
shanesuebsahakarnCommented:
You could try Stephen Leban's report utilities:
http://www.lebans.com/ReportUtilities.htm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.