Checkbox won't resize

[rpbsr]

I've added a bound checkbox control, but it is very small by default. I have
tried resizing it using the handles, but the checkbox itself does not change.
Can it be resized? Its awfully small.

Thanks.

 

[Graham R Seach]

No, it can't be resized, but you can resize it's label control.

If you really need a larger CheckBox, the thing to do is place two pictures
of (larger) Checkboxes on the form; one for the Checked state and one for
the Unchecked state, and make the appropriate one visible at the appropriate
time. You'll need to write code to set the value of the real (now hidden)
bound CheckBox depending on which picture is currently visible. Additional
code in the form's Current event must check the value of the real Checkox
and make the appropriate picture visible on a record-by-record basis.

It's a bit of work, but it'll give you what you want. Personally, I'd just
use the intrinsic control.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[fredg]

I've added a bound checkbox control, but it is very small by default. I have
tried resizing it using the handles, but the checkbox itself does not change.
Can it be resized? Its awfully small.

Thanks.

On a form?
You can not re-size the Access check box itself, but you can work
around it.

For use on a form in Single Form View.

Add an unbound text control to the form.
Set it's FontStyle to Wingdings.
Set it's FontSize to 24 (to start with).
Set the control's Width property to 0.3"
Set it's height to 0.3"
Set it's BorderStyle to Solid.
Border Width to 1 pt.
Name this control 'LargeCheck'.

Code it¢s click event:

Me.[CheckBoxName] = Not Me.[CheckBoxName]
If Me.[CheckBoxName] = True Then
Me.LargeCheck = Chr(252)
Else
Me.LargeCheck = ""
End If

Code the Form's Current event:

If Me.[CheckBoxName] = True Then
Me.LargeCheck = Chr(252)
Else
Me.LargeCheck = ""
End If

Clicking the cursor on the LargeCheck control will toggle it's value
just as a regular check box.
Note: You can colorize this control also.
If you change the font size, re-size the control around the check mark
also.

Change [CheckBoxName] to whatever the actual name of your Check box
control is.

Change the FontSize and the controls width and height as wanted.

 

[Graham R Seach]

Aahhh, I much prefer that way. Kewl Fred!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I've added a bound checkbox control, but it is very small by default. I
have
tried resizing it using the handles, but the checkbox itself does not
change.
Can it be resized? Its awfully small.

Thanks.

On a form?
You can not re-size the Access check box itself, but you can work
around it.

For use on a form in Single Form View.

Add an unbound text control to the form.
Set it's FontStyle to Wingdings.
Set it's FontSize to 24 (to start with).
Set the control's Width property to 0.3"
Set it's height to 0.3"
Set it's BorderStyle to Solid.
Border Width to 1 pt.
Name this control 'LargeCheck'.

Code it¢s click event:

Me.[CheckBoxName] = Not Me.[CheckBoxName]
If Me.[CheckBoxName] = True Then
Me.LargeCheck = Chr(252)
Else
Me.LargeCheck = ""
End If

Code the Form's Current event:

If Me.[CheckBoxName] = True Then
Me.LargeCheck = Chr(252)
Else
Me.LargeCheck = ""
End If

Clicking the cursor on the LargeCheck control will toggle it's value
just as a regular check box.
Note: You can colorize this control also.
If you change the font size, re-size the control around the check mark
also.

Change [CheckBoxName] to whatever the actual name of your Check box
control is.

Change the FontSize and the controls width and height as wanted.

 

[rpbsr]

I have completed the coding for the Click event, but I don't see a "Current"
event. What am I missing?

Aahhh, I much prefer that way. Kewl Fred!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I've added a bound checkbox control, but it is very small by default. I
have
tried resizing it using the handles, but the checkbox itself does not
change.
Can it be resized? Its awfully small.

Thanks.

On a form?
You can not re-size the Access check box itself, but you can work
around it.

For use on a form in Single Form View.

Add an unbound text control to the form.
Set it's FontStyle to Wingdings.
Set it's FontSize to 24 (to start with).
Set the control's Width property to 0.3"
Set it's height to 0.3"
Set it's BorderStyle to Solid.
Border Width to 1 pt.
Name this control 'LargeCheck'.

Code itʼs click event:

Me.[CheckBoxName] = Not Me.[CheckBoxName]
If Me.[CheckBoxName] = True Then
Me.LargeCheck = Chr(252)
Else
Me.LargeCheck = ""
End If

Code the Form's Current event:

If Me.[CheckBoxName] = True Then
Me.LargeCheck = Chr(252)
Else
Me.LargeCheck = ""
End If

Clicking the cursor on the LargeCheck control will toggle it's value
just as a regular check box.
Note: You can colorize this control also.
If you change the font size, re-size the control around the check mark
also.

Change [CheckBoxName] to whatever the actual name of your Check box
control is.

Change the FontSize and the controls width and height as wanted.

 

[rpbsr]

Fred,

Please forgive my stupidity. It was the form's Current event that I
overlooked. This was awesome. Thank you!

I have completed the coding for the Click event, but I don't see a "Current"
event. What am I missing?

Aahhh, I much prefer that way. Kewl Fred!

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

On Wed, 9 Jul 2008 16:22:06 -0700, rpbsr wrote:

I've added a bound checkbox control, but it is very small by default. I
have
tried resizing it using the handles, but the checkbox itself does not
change.
Can it be resized? Its awfully small.

Thanks.

On a form?
You can not re-size the Access check box itself, but you can work
around it.

For use on a form in Single Form View.

Add an unbound text control to the form.
Set it's FontStyle to Wingdings.
Set it's FontSize to 24 (to start with).
Set the control's Width property to 0.3"
Set it's height to 0.3"
Set it's BorderStyle to Solid.
Border Width to 1 pt.
Name this control 'LargeCheck'.

Code itʼs click event:

Me.[CheckBoxName] = Not Me.[CheckBoxName]
If Me.[CheckBoxName] = True Then
Me.LargeCheck = Chr(252)
Else
Me.LargeCheck = ""
End If

Code the Form's Current event:

If Me.[CheckBoxName] = True Then
Me.LargeCheck = Chr(252)
Else
Me.LargeCheck = ""
End If

Clicking the cursor on the LargeCheck control will toggle it's value
just as a regular check box.
Note: You can colorize this control also.
If you change the font size, re-size the control around the check mark
also.

Change [CheckBoxName] to whatever the actual name of your Check box
control is.

Change the FontSize and the controls width and height as wanted.