Access: make checkboxes editable not just border

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was trying to make the checkbox bigger on the Access forms. I checked thru
the help files and couldnt find anything. They are so small. When you
cllick on them to edit the size only the border is editable; the checkbox
stays the same size.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...d3b&dg=microsoft.public.access.tablesdbdesign
 
Fredg (MVP) has posted the following as a workaround:

Add an unbound label to the form detail section.
Set its Caption to "o" (small letter "o")
Set it's Font to WingDings
Set it's font size to whatever you want (perhaps 24)
Place this label where you wish to see the check mark.
I've named it LabelLargeCheck.
Set the actual CheckBox.Visible to No.

Code the Label's Click event:

Private Sub LabelLargeCheck_Click()
[CheckBox] = Not ([CheckBox])
If CheckBox Then
LabelLargeCheck.Caption = Chr(254)
Else
LabelLargeCheck.Caption = "o"
End If
End Sub

Code the Form Current Event:

Private Sub Form_Current()
If [CheckBox] Then
LabelLargeCheck.Caption = Chr(254)
Else
LabelLargeCheck.Caption = "o"
End If
End Sub

If you want a CheckBox field label then just add another
unbound label
and set its caption to the CheckBox field name. Leave it
Visible.

Don't forget to change the name of the CheckBox in this
coding to
whatever your Checkbox field is.
That should do it.

Clicking on the new Label is equivalent to clicking on the
CheckBox
field itself.
 
Back
Top