Simple One Line Code Question!!!

[Guest]

I am new in vba

What is the code to disable a text box in form? (Assume [TextBox] is the
text box)

Thanks in advance

Kennykee

 

[Nikos Yannacopoulos]

Me.Textbox.Enabled = False

in the form's own module, or:

Forms![Formname].TextBox.Enabled = False

in another module.

HTH,
Nikos

 

[David C. Holley]

Me![controlName].enabled = False

 

[David C. Holley]

N -

You left out mentioning that a trip to a good Irish Pub or an even
better Taverna is always a good idea.

Me.Textbox.Enabled = False

in the form's own module, or:

Forms![Formname].TextBox.Enabled = False

in another module.

HTH,
Nikos

I am new in vba

What is the code to disable a text box in form? (Assume [TextBox] is
the text box)

Thanks in advance

Kennykee

 

[Nikos Yannacopoulos]

N -

You left out mentioning that a trip to a good Irish Pub or an even
better Taverna is always a good idea.

No reason to repeat the obvious!

 

[David C. Holley]

Just trying to educate the idiot non-Greeks. Although I realize that its
mostly pointless.

 

[Guest]

Thanks

But how to disable only for one record but not for the whole field?

Thanks

KennyKee

Me![controlName].enabled = False

I am new in vba

What is the code to disable a text box in form? (Assume [TextBox] is the
text box)

Thanks in advance

Kennykee

 

[Guest]

Obviously you have been to the pub.
A field is part of a record, not the otherway round.
What are you really trying to do?

Thanks

But how to disable only for one record but not for the whole field?

Thanks

KennyKee

Me![controlName].enabled = False

I am new in vba

What is the code to disable a text box in form? (Assume [TextBox] is the
text box)

Thanks in advance

Kennykee

 

[Guest]

lol.....
I dont drink
Forget about the question

Thanks anyway

Obviously you have been to the pub.
A field is part of a record, not the otherway round.
What are you really trying to do?

Thanks

But how to disable only for one record but not for the whole field?

Thanks

KennyKee

Me![controlName].enabled = False

kennykee wrote:
I am new in vba

What is the code to disable a text box in form? (Assume [TextBox] is the
text box)

Thanks in advance

Kennykee

 

[David C. Holley]

To disable on a record-by-record basis, you'll want to use conditional
formating. Right click on the field and you should see it there in the
options.

Thanks

But how to disable only for one record but not for the whole field?

Thanks

KennyKee

:

Me![controlName].enabled = False

I am new in vba

What is the code to disable a text box in form? (Assume [TextBox] is the
text box)

Thanks in advance

Kennykee

 

[Guest]

Thanks David
You solve the puzzle
Thanks a lot.

To disable on a record-by-record basis, you'll want to use conditional
formating. Right click on the field and you should see it there in the
options.

Thanks

But how to disable only for one record but not for the whole field?

Thanks

KennyKee

:

Me![controlName].enabled = False

kennykee wrote:

I am new in vba

What is the code to disable a text box in form? (Assume [TextBox] is the
text box)

Thanks in advance

Kennykee