I have a COMBO box where there are different values/options to choose from
including "Others" and I only want the "other specify" textbox to be visible
if only they choose the option "Others". Could someone kindly help me write
the code?

Newby -

Here is the basic code. You will need to change the names of the text box
and the combobox to be your names. Also, I assume the "Others" is in the
first column of the combo box (Column(0)).

Me.txtOtherSpecify.visible = (Me.cboBox.Column(0) = "Others")

The right part of this statement that is between parentheses will evaluate
to True or False, and will thus set the .visible property of the text
accordingly.

Depending on the use of your form, you would want this code in the OnClick
event of the combo box, but you might also want it in the OnCurrent event of
the form, so it displays properly for any existing record.

--
Daryl S


"newby" wrote:

> I have a COMBO box where there are different values/options to choose from
> including "Others" and I only want the "other specify" textbox to be visible
> if only they choose the option "Others". Could someone kindly help me write
> the code?
>

Probably the After Update event of the combobox is the main event to use.

--
Steve Schapel, Microsoft Access MVP


"Daryl S" <(E-Mail Removed)> wrote in message
news:824C6B48-294A-436A-98F7-(E-Mail Removed)...
> Newby -
>
> Here is the basic code. You will need to change the names of the text box
> and the combobox to be your names. Also, I assume the "Others" is in the
> first column of the combo box (Column(0)).
>
> Me.txtOtherSpecify.visible = (Me.cboBox.Column(0) = "Others")
>
> The right part of this statement that is between parentheses will evaluate
> to True or False, and will thus set the .visible property of the text
> accordingly.
>
> Depending on the use of your form, you would want this code in the OnClick
> event of the combo box, but you might also want it in the OnCurrent event
> of
> the form, so it displays properly for any existing record.
>
> --
> Daryl S
>
>
> "newby" wrote:
>
>> I have a COMBO box where there are different values/options to choose
>> from
>> including "Others" and I only want the "other specify" textbox to be
>> visible
>> if only they choose the option "Others". Could someone kindly help me
>> write
>> the code?
>>

Hi Daryl -

For some reasons, the code is not working and I don't know what I am doing
wrong, it keeps highlighting the "column" part. The "Other, please specify"
is in column (4) as in I have 5 options that I typed in by myself (did not
use the wizard). Could you kindly tell me what I am doing wrong? This is my
code:
Me.IfNoTypCnst_plsSpfy.visible = (Me.IfNoTypCnst.Column(4) = “Other, please
specify”)

Thanks.

"Daryl S" wrote:

> Newby -
>
> Here is the basic code. You will need to change the names of the text box
> and the combobox to be your names. Also, I assume the "Others" is in the
> first column of the combo box (Column(0)).
>
> Me.txtOtherSpecify.visible = (Me.cboBox.Column(0) = "Others")
>
> The right part of this statement that is between parentheses will evaluate
> to True or False, and will thus set the .visible property of the text
> accordingly.
>
> Depending on the use of your form, you would want this code in the OnClick
> event of the combo box, but you might also want it in the OnCurrent event of
> the form, so it displays properly for any existing record.
>
> --
> Daryl S
>
>
> "newby" wrote:
>
> > I have a COMBO box where there are different values/options to choose from
> > including "Others" and I only want the "other specify" textbox to be visible
> > if only they choose the option "Others". Could someone kindly help me write
> > the code?
> >

Newby -

The 4th column in the combo box would be column(3), as the first column is
column(0).

--
Daryl S


"newby" wrote:

> Hi Daryl -
>
> For some reasons, the code is not working and I don't know what I am doing
> wrong, it keeps highlighting the "column" part. The "Other, please specify"
> is in column (4) as in I have 5 options that I typed in by myself (did not
> use the wizard). Could you kindly tell me what I am doing wrong? This is my
> code:
> Me.IfNoTypCnst_plsSpfy.visible = (Me.IfNoTypCnst.Column(4) = “Other, please
> specify”)
>
> Thanks.
>
> "Daryl S" wrote:
>
> > Newby -
> >
> > Here is the basic code. You will need to change the names of the text box
> > and the combobox to be your names. Also, I assume the "Others" is in the
> > first column of the combo box (Column(0)).
> >
> > Me.txtOtherSpecify.visible = (Me.cboBox.Column(0) = "Others")
> >
> > The right part of this statement that is between parentheses will evaluate
> > to True or False, and will thus set the .visible property of the text
> > accordingly.
> >
> > Depending on the use of your form, you would want this code in the OnClick
> > event of the combo box, but you might also want it in the OnCurrent event of
> > the form, so it displays properly for any existing record.
> >
> > --
> > Daryl S
> >
> >
> > "newby" wrote:
> >
> > > I have a COMBO box where there are different values/options to choose from
> > > including "Others" and I only want the "other specify" textbox to be visible
> > > if only they choose the option "Others". Could someone kindly help me write
> > > the code?
> > >