Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

DoCmd.SendObject acSendReport checkBoxes are not shown

Posted on 2004-08-29
11
Medium Priority
?
704 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 200 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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
 
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Implementing simple internal controls in the Microsoft Access application.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

564 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