Access Video Quiz A2.3
By Richard Rost
18 hours ago
Can Standalone Macro Change Toggle Button Caption? What happens when two bound controls on the same form use the same yes-no field as their control source? Welcome to another Microsoft Access Video Quiz. You will be asked five Advanced-level questions covering Access forms, events, bound controls, standalone macros, and using Set Value to update a control caption. Answer each question, check your score, and see how well you know Microsoft Access. Recommended CoursesWant More?Keywords Access Video Quiz, Access forms events, On Current event, bound controls same field, standalone macros, RunMacro action, Set Property macro action, Set Value macro action, control caption, toggle button caption, Forms! reference
More InformationTranscript It's time for another video quiz from Access Learning Zone. This one's for Advanced Users.
I've got five questions for you covering Access Forms and Events. You'll have three seconds to answer each question, so use that pause button if you need more time, and you will need that pause button for this one.
Keep track of your score so you can see how you did at the end.
Are you ready to take the bridge?
All right, here we go.
Question 1: What happens when two bound controls on the same form use the same yes-no field as their control source?
Only the first control can update the field.
Each control stores a separate copy of the value.
Both controls reflect and edit the same underlying field value.
Access automatically converts one control into a label.
That's going to be both controls reflect and edit the same underlying field value, and it works with text boxes and all kinds of other stuff too.
Question 2: Which form event is useful for updating controls whenever the user moves to a different record, including when the form first opens?
Is it On Current, On Click, Before Insert, or On Close?
Question 3: A form's On Current event and a toggle button's event must both perform the same sequence of macro actions. What's the best design?
Copy the actions into both embedded macros.
Put the actions in a standalone macro and use Run Macro from both events.
Put the actions in the table's validation rule.
Create a separate copy of the form for each event.
That is, put the actions in a standalone macro and use Run Macro from both events.
Question 4: Why can the Set Property macro action fail when a standalone macro tries to change a control on a named form?
Set Property can only change captions, not values.
Standalone macros cannot work with open forms.
Set Property is limited to controls in the form containing the embedded macro.
A form control must first be converted to an unbound control.
That is, Set Property is limited to controls in the form containing the embedded macro.
All right, you want to use the pause button for this one. In a standalone macro, which setup correctly assigns the literal caption "Invoice" to a toggle button named StatusToggle on an open form named OrderF?
There are your options. I'm not reading them all.
Take that pause button now and figure it out.
That's going to be answer B: Set Value, where the item equals Forms!OrderF!StatusToggle.Caption and the expression equals "Invoice," just like that.
Well, except whatever it will say, "Invoice."
All right, how'd you do?
There were some tricky ones in this quiz. Did you get all five right?
Did you chart the impossible nebula and make it home for dinner?
Or did you set course for Earth and forget the coordinates?
Well, if you missed any of these, they're all covered in Access Advanced Level 2, Lesson 3.
Thanks for playing. Post your score in the comments down below and let us know whether your form controls stayed in sync or went full red alert.
Until next time, live long and prosper. Intro What happens when two bound controls on the same form use the same yes-no field as their control source? Welcome to another Microsoft Access Video Quiz. You will be asked five Advanced-level questions covering Access forms, events, bound controls, standalone macros, and using Set Value to update a control caption. Answer each question, check your score, and see how well you know Microsoft Access. |
