In this video, I will show you how to show or hide a button depending on the value of a field in a continuous form. You can't use the Visible property, so we will use a trick involving Conditional Formatting and a Transparent Button.
Micah from Titusville, Florida (a Gold Member) asks: I have a continuous form showing my customers. I have a particular form that needs to be filled out but ONLY if the customer is from Florida. Is there any way to show that button for just those customers? I can do it on a Single Form using the visible property, but if I try the same thing on a Continuous form, it changes ALL of the buttons.
BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members will learn how to make it so that the open form code does not run if the button is not visible using VBA and an OnClick event.
MEMBERS VIDEO:
https://youtu.be/vApjysFi24g
BECOME A MEMBER:
YouTube:
https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site:
https://599cd.com/THMember
LEARN MORE:
https://599cd.com/ShowHideButtonsCont
LINKS:
On Current Event:
https://599cd.com/OnCurrent
Continuous Forms:
https://599cd.com/Continuous
Conditional Formatting Expression:
https://599cd.com/Expression
COURSES:
FREE Access Beginner Level 1:
https://599cd.com/Free1
$1 Access Level 2:
https://599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates:
https://599cd.com/THFree
Blank Template:
https://599cd.com/Blank
Contact Management:
https://599cd.com/Contacts
Order Entry & Invoicing:
https://599cd.com/Invoicing
More Access Templates:
https://599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Get on my Mailing List:
https://599cd.com/YTML
Contact Me:
https://599cd.com/Contact
TechHelp:
https://599cd.com/TechHelp
Paid TechHelp Questions:
https://599cd.com/TechHelpPaid
Consulting Help:
https://599cd.com/Consulting
Twitter:
https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, show, hide, buttons, continuous forms, visible, conditional formatting, expression is, transparent button
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Тэги:
#microsoft_access #ms_access ##msaccess ##microsoftaccess ##help ##howto ##tutorial ##instruction ##learn ##lesson ##training ##database #show #hide #buttons #continuous_forms #visible #conditional_formatting #expression_is #transparent_button