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!

Checkbox trouble!!!

Status
Not open for further replies.

sera

Technical User
Jun 29, 2000
360
US
Hello all!
I am trying to make my reports look "clean" when they have been converted to Microsoft Word. I know of the .snp format but cannot use it, so it is not a viable solution here. I need to somehow get the data from checkboxes to appear on the Word side. When I convert a report to Microsoft Word I get all the labels associated to the checkboxes but I don't get the data associated to the checkbox. I am thinking that what I need to do is create an unbound text box and fill it with the value of the field if it is true. An examle is:
Site Age: Prehistoric - value is true
Historic -value is false
so the unbound textbox would display "Prehistoric".
Unfortunately I don't know how to implement this...maybe you do?
Sera
 
Try setting the control source of that text box to something like:

=IIf([Site Age] = "True", "Prehistoric", "Historic")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top