D djt2009 New member Local time Today, 21:55 Joined Oct 21, 2009 Messages 5 Dec 10, 2009 #1 Hello all. Is it possible to show and hide certain fields on a form, based on whether a check box is ticked or not?
Hello all. Is it possible to show and hide certain fields on a form, based on whether a check box is ticked or not?
M MStef Registered User. Local time Today, 21:55 Joined Oct 28, 2004 Messages 2,250 Dec 10, 2009 #2 Try via "Visible" property. Me.[Field Name].Visible = True or Me.[Field Name].Visible = False
John Big Booty AWF VIP Local time Tomorrow, 08:55 Joined Aug 29, 2005 Messages 8,243 Dec 10, 2009 #3 If you want to show a field when the check box is checked and hide it when it is unchecked, try; Code: Me.YourFieldName.Visible = Me.CheckBoxName As the Check box will return a True (checked) or False (unchecked) result you can use it directly to show or hide the field via it's Visible property.
If you want to show a field when the check box is checked and hide it when it is unchecked, try; Code: Me.YourFieldName.Visible = Me.CheckBoxName As the Check box will return a True (checked) or False (unchecked) result you can use it directly to show or hide the field via it's Visible property.
D djt2009 New member Local time Today, 21:55 Joined Oct 21, 2009 Messages 5 Dec 10, 2009 #4 Thanks for your ideas. Cheers.