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 · 74803 Viewers
80 Video lessons · 129869 Viewers
52 Video lessons · 64070 Viewers
59 Video lessons · 49865 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.