- missing checkboxes?? - rtf file -

[jayme]

im using ms access 2000...
i have a form in my db that gets filled out and then it has a control to email that form to certain email addresses.
there are several checkboxes on this form - when it gets emailed it is attached as an rtf file-then it opens in word. all that is fine-but when it opens none of the checkboxes show up. the label(words) are there but you can't tell which ones are checked off since the boxes arent there.
is there a way to get the checkboxes to show up??

[NeoPa]

Ah, Now I understand the problem better.
I think you'll find (Better check as I'm not 100% on this) that this is a limitation of the RTF format itself. It is designed to give a Richer Text Format and isn't as fully featured as say a Word document.

[jayme]

Ah, Now I understand the problem better.
I think you'll find (Better check as I'm not 100% on this) that this is a limitation of the RTF format itself. It is designed to give a Richer Text Format and isn't as fully featured as say a Word document.

oh-ok..well if that is true-do you know of a way to be able to display the checkboxes? as far as another format or another route or whatever...becu ase there a few checkboxes on there that are pretty important to show the checks.

[NeoPa]

Is it simply for display, or does it need to be interactive in some way?

[jayme]

Is it simply for display, or does it need to be interactive in some way?

just to display

[NeoPa]

I don't really know how to automate it, but using PDF files may work. They should certainly contain the whole form as if printed. I believe automating that may be tricky but, as I say, I can't help you there as I don't know how.
There may be other possible formats. Maybe someone can think of something more helpful.

[jayme]

yeah-i think pdf might be my best bet too! ill look into that today...if anyone has an easy way of doing that let me know!!
thanks for your help!

[jayme]

well i think i might have it. i tried just changed the RTF format in the code to PDF then it came up with a message box asking which format i wanted to use and it gave me a few options. so i chose snapshot just to see what that would do-and it looks like this is going to work. so i went back and changed the PDF to SNP and it attaches a snp file in the email and opens up in a snapshot viewer-which looks basically like a pdf - so i think this will work! thanks.

[NeoPa]

Snapshot IS basically like a PDF in that it shows exactly as it would be printed (On a colour printer). The drawback with SNP files is that the recipient needs the software installed to view them. If you don't have any problems in that area then you should be good. I found (With some older OSs - Win 98 etc) that there could be problems running the snapshot Viewer software even if it were installed.
Glad you got a workable solution anyway :)

[jayme]

ok-thanks. i will check to make sure everyone involved with this has the snapshot viewer on their computer. i appreciate it. thanks again for your input!