Check Box size

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

Hello
I'd like the Check box in my report to be bigger. When I go to change the
size, it changes the outer field but the box remains the same size. How can
I do this?
Also is there a way to have "Yes" or "No" to show instead of the check box?

Thanks
 
You can't and No.

For what you want, you might consider an option group with two toggle
buttons with captions of Yes and No.
 
Hello
I'd like the Check box in my report to be bigger. When I go to change the
size, it changes the outer field but the box remains the same size. How can
I do this?
Also is there a way to have "Yes" or "No" to show instead of the check box?

Thanks
Click to expand...

Take your pick.
1) A larger check box...
Include the regular check box in the section. Make it not visible.

Add an unbound text control to the report.
Set it's FontStyle to Wingdings. Let's start with FontSize of 26 and
see if that is too big or too small. You can adjust it later.
Name this unbound control 'LargeCheck'.

Code the Detail Section's Format event (if that is where the check is
being placed):

If Me.[CheckBox] = -1 Then
Me.[LargeCheck] = chr(254)
Else
Me.[LargeCheck] = chr(111)
End If

Run the report. Adjust the FontSize larger or smaller as wanted.
Size the control's height and width to display the entire check box.

2) Display Yes or No....
Add an Unbound text control to the report.
Set it's control source to the Check Box field.
Set it's format property to:
;"Yes";"No";
 
Thank you, I'll play with both.
Cheers

fredg said:
Hello
I'd like the Check box in my report to be bigger. When I go to change the
size, it changes the outer field but the box remains the same size. How
can
I do this?
Also is there a way to have "Yes" or "No" to show instead of the check
box?

Thanks
Click to expand...

Take your pick.
1) A larger check box...
Include the regular check box in the section. Make it not visible.

Add an unbound text control to the report.
Set it's FontStyle to Wingdings. Let's start with FontSize of 26 and
see if that is too big or too small. You can adjust it later.
Name this unbound control 'LargeCheck'.

Code the Detail Section's Format event (if that is where the check is
being placed):

If Me.[CheckBox] = -1 Then
Me.[LargeCheck] = chr(254)
Else
Me.[LargeCheck] = chr(111)
End If

Run the report. Adjust the FontSize larger or smaller as wanted.
Size the control's height and width to display the entire check box.

2) Display Yes or No....
Add an Unbound text control to the report.
Set it's control source to the Check Box field.
Set it's format property to:
;"Yes";"No";
Click to expand...
 
Back
Top