Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

checkboxes in reports 2

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Hello,

I am trying to convert an Access Report into a .rtf document to be sent weekly by email to clients. When Access does the convertion, the checkboxes disappear!!!
Any advices are welcome.
Thanx in advance.

Zoubi_la_mouche
 
Rather than use the checkboxes, make a textbox that looks at the field and provides a Yes/No answer.

Sample Code: set this as controlsource in your controls.
=iif([MyCheckBoxField]=-1,"Yes","No")

.RTF doesn't support anything but text, so you won't be able to get the checkboxes to appear. If you need the checkboxes you'll have to use SnapShot or possible Word format.

HTH
Joe Miller
joe.miller@flotech.net
 
You also lose other formatting when exporting to word as well. I had to enter - - - - - - - in a label in order to show record breaks. Using the line tool from access shows up fine in access, or when printing from access, but most other formatting gets lost.
-Smack
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top