Solved

DoCmd.SendObject acSendReport checkBoxes are not shown

Posted on 2004-08-29
11
694 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:lzha022
  • 5
  • 3
  • 3
11 Comments
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 11927763
Do they show if you print or preview the report?
0
 
LVL 7

Accepted Solution

by:
rockmuncher earned 100 total points
ID: 11927775
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
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 11927785
They should show up in snapshot format though (which the questioner did say he'd tried).
0
 
LVL 7

Expert Comment

by:rockmuncher
ID: 11927796
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
 

Author Comment

by:lzha022
ID: 11927934
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
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 11927939
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
 
LVL 7

Expert Comment

by:rockmuncher
ID: 11927955
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
 

Author Comment

by:lzha022
ID: 11928094
I think you all know that the report that is not printing properly is the received one in the form of RTF.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 11928152
Follow rockmuncher's instructions on changing the checkboxes to text or combo boxes.
0
 

Author Comment

by:lzha022
ID: 11959599
So there is no way to show those check boxes on the RTF report?
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 11959660
You could try Stephen Leban's report utilities:
http://www.lebans.com/ReportUtilities.htm
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now