frame

[00KobeBrian]

How do you add a checkbox to an existing frame control in a form with access
97? Thanks.

 

[Dirk Goldgar]

How do you add a checkbox to an existing frame control in a form with
access 97? Thanks.

So as to create another option in the option group, you mean? With the
form open in design view, click the check box tool in the tool box, then
move your mouse over the option group. The background of the frame will
be highlighted -- just click in the highlighted frame and the check box
will be added to the group. Then you can tinker with its properties, if
you want.

 

[00KobeBrian]

Thanks. It works. How do you chang the option value and can I use character
as option value? Thanks.

 

[Guest]

Click the checkbox
Open its properties
Go to the DATA tab where you can see the Option Value

 

[Dirk Goldgar]

Thanks. It works. How do you chang the option value and can I use
character as option value? Thanks.

You can't set a character as the option value. Option groups always
have numeric values. For display in a report, you can use a function to
translate the numeric value to a letter or meaningful text if you want.

 

[00KobeBrian]

Thanks. How do you specify or set a checkbox is selected in a frame in the
CODE? Thanks.

 

[Dirk Goldgar]

Thanks. How do you specify or set a checkbox is selected in a frame
in the CODE? Thanks.

You set the value of the option group frame to the Option Value of the
specific checkbox inside it. So if you have three check boxes in group
Frame1, with option values 1, 2, and 3, issuing the statement

Me!Frame1 = 2

will select the second check box. Note that it's the Option Value
properties that control this; if the check boxes had option values 1,
3, 2 (in that order), you'd select the second one with

Me!Frame1 = 3