Combo Box - Quick Question

[ssignore]

Hello MS Online Community!
I have a combo box with 4 possible selections. One of the selections is
"Other". Is it possible (without VB scripting!) that when a User chooses
"Other" from the combo box to have a text or memo box enabled for additional
entry? Only if "Other" is chosen?
Many thanks for the help!
Regards,
Simone

 

[Douglas J. Steele]

Without code? No, I don't see any way it's possible.

However, it's only 1 line of code:

Private Sub MyComboBox_AfterUpdate()

Me!MyMemoField.Enabled = (Me!MyComboBox = "Other")

End Sub

 

[NG]

Hi,

I dont think it's possible without a little VBA or macro, but it takes very
little code to achieve:

in the "AfterUpdate" event of the combo box , write something like:
If me.Combo = "other" then
me.txtExtraInfo.enabled = true
else
me.txtExtraInfo.enabled = false
end if

To be correct you can enter this code also in the Oncurrent event of the
form. This way the user can always alter the extra info if the current
record contains "Other" info.

 

[ssignore]

Many thanks, Noëlla! We'll give it a shot!

Hi,

I dont think it's possible without a little VBA or macro, but it takes very
little code to achieve:

in the "AfterUpdate" event of the combo box , write something like:
If me.Combo = "other" then
me.txtExtraInfo.enabled = true
else
me.txtExtraInfo.enabled = false
end if

To be correct you can enter this code also in the Oncurrent event of the
form. This way the user can always alter the extra info if the current
record contains "Other" info.

 

[ssignore]

Thanks for the response, Doug! I'll see if I can make it work!

 

[ghetto_banjo]

You will have to do it with VB scripting i believe.

But it is pretty easy!


On the After Update event of your combo box,
use this code:

Private Sub ComboBoxName_AfterUpdate()

if me.comboBoxName = "Other" then
me.textBoxName.enabled = True
else
me.textBoxName.enabled = False
end if

End Sub

 

[tina]

you'll have to use VBA or a macro.

hth