Oct 12 2006, 03:52 PM
i have several checkboxes on a report. is there a way to remove the box around the checkbox?
Oct 12 2006, 04:18 PM
Not directly in Access as far as I'm aware. You could create a graphic (or maybe use a font that includes a tick in a textbox) and hide/unhide the image or textbox depending on the value of your (hidden) checkbox
Oct 12 2006, 04:30 PM
Another way is in the query add an IIF statement to say IIF([CheckBox]=yes,"Yes","No")
You can then add this to the report instead of the checkbox.
Just an approach I have used before.
Oct 12 2006, 05:52 PM
another approach would be to use wingdings characters in labels or textboxes to simulate the checkbox.
Check this discussion
for more on this.
Oct 12 2006, 06:19 PM
Jim, i like your idea, however i need checkmarks to appear, not yes/no. its just the boxes i want to hide.
Oli. i've looked at the samples using wingdings. however using that method, it doesnt seem possible to bind it to a field.
i thought there was a simple solution :(
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here