Check Box size

[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

 

[Klatuu]

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.

 

[fredg]

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

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";

 

[JB]

Thank you, I'll play with both.
Cheers

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

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";

 

[ÎéËØÀò]

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.