Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

How do I ????

Locked

Hello,
I need to know how I get a memo field on MSAccess 2000 to stay unactivated until a yes/no check box is checked and then the memo field becomes active and allows info to be typed in it. Or if the check box is un-checked the memo field becomes un-active again.

Thank you

Topic

Reply To: How do I ????

In reply to How do I ????

That is actually pretty simple. On your form, create a checkbox and textbox. I’ll call them Check1 and Text2. nder properties, set the default value for Check1 to false, and set Enabled property for Text2 to disabled. Create an event for AfterUpdate on Check1 as follows:

Private Sub Check12_AfterUpdate()
If Check1.Value = True Then
Text2.Enabled = True
Else: Text2.Enabled = False
End If
End Sub

This will result in the form defaulting to checkbox unchecked and the textbox disabled. When the box is checked, textbox will be enabled. If it is unchecked, the textbox will go back disabled.

Hope this helps.

Reply To: How do I ????

In reply to Reply To: How do I ????

Sorry, typo in code….

That should be “Private Sub Check1_AfterUpdate”

Thanks

Reply To: How do I ????

In reply to Reply To: How do I ????

Poster rated this answer.

Reply To: How do I ????

In reply to How do I ????

This question was closed by the author

[Author]

Replies