Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
You may have fields in your Database that you need for usage, but they don't belong on your printouts. You can specify your fields appeared just onscreen, just in the printouts or both, which is the default. Scroll down in the Navigation pane and open up the Customer Order Form. Up in the corner we have a Flag field that we use to mark records to take action on them. But no matter whether they're checked or not, they are not necessary on the printout, in fact, it could be confusing, so let's hide them on the printouts. Switchover to the Design View, I am going to use the little button in the bottom right-hand corner of the screen.
Turn on the Property Sheet, either from this button on the ribbon or by pressing F4 on your keyboard. Click on the Flag label and hold the Shift key down and click on the check mark as well so that both of the two are highlighted. Go to the Format tab in the Property Sheet, and the last item is Display When, right now it says Always, which means that it's going to show both onscreen and on printouts. If we change this to Print Only, it would show, when we look at it onscreen, but you would see it on the printouts. And I am going to make it Screen Only.
Now, I'll switch back to Form View using this little button in the right-hand corner, I can still see Flag right here, but I go to the File menu and down to Print and across to Print Preview, and my Flag field no longer shows on my printout. Display When is a great field when you want the same form to look slightly different onscreen and on paper, you can hide fields on one or the other, as needed.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64772 Viewers
80 Video lessons · 124353 Viewers
52 Video lessons · 60287 Viewers
59 Video lessons · 46113 Viewers