Bigger check boxes?

[jimtimber]

Hi,

I see that I can't make the tick/check bigger in properties. Is there a way of getting a bigger one on the report at all? I have about 30 to do on a report so I'm praying its not a lot of work each time. I saw on Google that someone suggested using Wingdings tick but not sure how to do that.

Thanks for any suggestions.

J

 

[Isskint]

Do you just want the tick to display bigger on a report OR do you want a bigger box to physically tick on the report?

 

[jimtimber]

Hi Isskint

I want a bigger tick on the report. I've found I can do it by

1) Hiding original checkbox
2) inserting a text box, changing font to Wingdings2 and pasting =IIf([Field]=True,"P","") into the control source.

I was wondering if there was an easier way. Google suggests there isn't :/

J

 

[Isskint]

jim,

Essentially that is the way to do it. 2 things though;

1. You can completely remove the checkbox.
2. I would actually do it at the query level, providing a blank or P for the report control

 

[jimtimber]

Thanks Isskint.


When you do it in the query, do I change the font there or do I do it in the report still?


j

 

[vbaInet]

Put the IIF() in the query but set the Winding font type in the report. It's a report so it won't much of a difference if it's in the query or the Control Source, and in fact it would be better suited in the report itself if the report is being opened in Report View.