frame

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

"00KobeBrian" wrote in message

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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

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


"Dirk Goldgar" wrote in message
...
"00KobeBrian" wrote in message

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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

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




"00KobeBrian" wrote:

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


"Dirk Goldgar" wrote in message
...
"00KobeBrian" wrote in message

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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"00KobeBrian" wrote in message

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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

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


"Dirk Goldgar" wrote in message
...
"00KobeBrian" wrote in message

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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"00KobeBrian" wrote in message

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

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)