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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Checkboxes Not Printing in Access Report

Status
Not open for further replies.

planner512

Technical User
Jul 2, 2003
1
US
Checkboxes in my access report and form show up on print preview but when I print the documents the checkboxes do not print. Any ideas?
 
Hey planner512,
make sure that in the checkbox properties the "Display When" property is set to "Always".

JASON
 
I searched for this, exactly what I'm having problems with, but I can't find a Display When in my Properties.

Any help?

I looked in both the 97 and the 2000 versions. I must be missing something.

Please help!
Thanks,
MRsTFb
 
This might be a little late, but it may be worth the tip:

There is a check mark in the Wingdings font that you can use on a report.
Place a textbox control on the report, set its Font property to Wingdings, and then place the checkmark into it.
Leave the original checkbox control on the form, but set its Visible property to No to make it invisible.
(You may need to first insert the check mark symbol into a Word document and then copy and paste it into the Access textbox’s Control Source property, using the syntax ="ü" CharMap.exe used to do this also.)

Make the check mark visible only when the Yes/No field has a value of True, open the report Detail section’s Format event procedure and enter the following code:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me![FieldName] = True Then
Me![txtCheckmark].Visible = True
Else
Me![txtCheckmark].Visible = False
End If
End Sub
(Of course, substitute [FieldName] with your checkbox field)


Hope it helps
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top