[Last Call] Learn how to a build a cloud-first strategyRegister Now


Tick box enlarged

Posted on 2004-11-11
Medium Priority
Last Modified: 2008-02-01
is there any way to enlarge the tick box on a form

i'm not very farmilier with access so a detail explanation would be prefered

thanx for your time and help
Question by:gangsterboss
  • 4
LVL 39

Expert Comment

ID: 12558496
unfortunately ... no ... the size of the checkbox is fixed. You cold use a texbox and set the font to an appropriate size and then add / remove the letter "X" in the click event and then translate that to your field that is expecting -1 or 0. More work than it is worth.

LVL 58

Accepted Solution

harfang earned 80 total points
ID: 12564114
To create a Large Checkbox, you need three controls...

1) you have a check box, let's call it chkTiny, with a label. In the properties, set the width and height to 0, this will leave only a tiny grey spot.

2) create a textbox, for example txtTinyLARGE, with the control source set to:
    = IIf( chkTiny, "a", "")
Set the following properties: Enabled: No, Locked: Yes.
Set the font to something where "a" looks like a check mark, i.e. Webdings...
An of course, choose a large font size and enlarge the text box...
Ah, yes, delete its label...

Now you have a large check box. The only problem left is that you can check it only by clicking on the label, not on the "check box" itself... This is where the third control comes in:

3) Create a button, having the same size as txtTiny, exaclty *over* it (hiding it). Let's call it cmdCheckTiny.
In the properties of the button, set Transparent: Yes, and Tab Stop: No
Then go to the "On Click" property, select "[event handler]" and press the builder button: [...]

In the module, adjust the code to read:

Private Sub cmdCheckTiny_Click()
    chkTiny = Not chkTiny
End Sub

There you go.... As Steve said... probably "more work than it is worth"...

LVL 58

Expert Comment

ID: 12564123
Hmm, when I say "by clicking on the label", I mean of course the label of the check box, that is still visible...
LVL 58

Expert Comment

ID: 12564156
Maybe I should mention another trick here...

If you consider the boxes too small for clicking on them, not for reading them, you can enlarge the label to cover an area around the check box itself:

    | click here:        [v]       |

This way, a slight "misclick" will still check/uncheck the box.

LVL 58

Expert Comment

ID: 12564175
Yet another afterthought...

By using the last solution, i.e. a large label, you could leave step 3) out... no need for a tranparent button as the checkbox label will do the job quite well!

Out for now :)


Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month17 days, 14 hours left to enroll

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question