Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

DoCmd.SendObject acSendReport checkBoxes are not shown

Posted on 2004-08-29
11
Medium Priority
?
703 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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…

610 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