Hide text untill click of a button

[CHEECO]

I have an unusual question. I am making a small riddle data base for a boy that is in hospital. It will keep his mind bust during his hospital stay. I want to hide the text to the answer and it only be viewable when the I give up button. My idea is to have a form with the riddle and a sub form with the text of the answer. But the answer text cannot be seen until the I give up button is pushed. I have the form with the sub form created but I have no idea how to hide the text of the answer until the button is clicked. I am using Access 2016.



Thank-you and happy holidays

Cheeco

[CHEECO]

I figured it out. Now the below information also work with access 2016.

APPLIES TO: ACCESS2007, 2010 (UNTESTED IN EARLIER VERSIONS)
The following tutorialshows you how you can use VBA to hide a form field in an access form followingthe update of a text box or after the click of a button and how to make itvisible again.
For this tutorial you willneed to create the following fields /controls on your Access form:
A text box called“textbox1” (the box that will be updated)
A text box called“textbox2” (the box that will be hidden)
A command button Called“btnVisible”
1. Select the text box
2. In the tools section ofthe “Design” tab click on the item called “Property Sheet”
3. Select the “Event” tab
4. On the “After Update”property click on the little black down arrow / triangle and select “EventProcedure”
5. Click on the three dotsnext to the little black down arrow / triangle – this will open up the VBAwindow and you should see the following:
Private Subtextbox1_AfterUpdate()
End Sub
6. On a new line directlybetween the two lines above add the following
Me.textbox2.Visible= False
7. Go back to your form andselect the command button called “btnVisible”
8. In the tools section ofthe “Design” tab click on the item called “Property Sheet” and select the“Event” tab
9. On the “On Click”property click on the little black down arrow / triangle and select “EventProcedure”
10. Click on the three dotsnext to the little black down arrow / triangle – this will open up the VBAwindow and you should see the following:
Private SubbtnVisible_Click()
End Sub
11. On a new line directlybetween the two lines above add the following
Me.textbox2.visible= True
Save your changes and testyour form / report
Note: The text boxwill only be hidden once the user has finished entering data and clicked awayfrom the field.
You can adapt the aboveoption in many ways to hide or make visible any controls on your form.
If you want a field to behidden when the form first loads do the following:
2.1 Select the field youwant to be hidden when the form loads
2.2 In the tools section ofthe “Design” tab click on the item called “Property Sheet” and select the“Format” tab
3.2 Change the “Visible”property to “No”
Save your changes and testyour form / report