Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Modifying the form through its properties

From: Access 2010: Forms and Reports in Depth

Video: Modifying the form through its properties

The Format tab on the Ribbon gives you a quick place to change some of the most common settings for your form elements, such as color, font, and size. But those options are only the tip of the iceberg when it comes to the vast number of properties that each element possesses. To see the full list, we will have to dive into the Property Sheet. I have got my Employee Directory form open form the last movie. We are going to go ahead and change our view back to Design view here. We will go ahead and get rid of the Field List window by clicking the x here, and I am going to turn on the Property Sheet. The Property Sheet has lots of different ways you can get to it. First you can find it in the Design tab of the Ribbon, under the Property Sheet button here, and I can press the shortcut key Alt+Enter or another shortcut key. F4 and that one is actually my favorite one.

Modifying the form through its properties

The Format tab on the Ribbon gives you a quick place to change some of the most common settings for your form elements, such as color, font, and size. But those options are only the tip of the iceberg when it comes to the vast number of properties that each element possesses. To see the full list, we will have to dive into the Property Sheet. I have got my Employee Directory form open form the last movie. We are going to go ahead and change our view back to Design view here. We will go ahead and get rid of the Field List window by clicking the x here, and I am going to turn on the Property Sheet. The Property Sheet has lots of different ways you can get to it. First you can find it in the Design tab of the Ribbon, under the Property Sheet button here, and I can press the shortcut key Alt+Enter or another shortcut key. F4 and that one is actually my favorite one.

The other way you can do it is just double-click on an object. For instance, if I double-click on my LastName here, it will open up the Property Sheet for that object. Now every object on your form, including the background, if I click back here, and the form itself, if I click on the box up here, have properties. Let's look at some of the things that we might want to change. Let's go back into Form view for a moment. Now in my Employee directory, first of all, I want to make this a scrolling form, so that each record appears right on top of the other. Next, I want to get rid of some of the clutter. This thing over here on the left side is called s record selector, this big gray bar with the arrow on top of it. You can click on it and it turns black, but it doesn't look like it does anything else.

Let me show you a record selector at a table, just so you can see what this is. If I open up the Employees table here, the record selector is this gray box here. It selects the entire row. So I can go through and select different rows. That's what a record selector is. Let me close the table. So in the form right now, the record is this entire thing. So the record selector extends all the way from the top to the bottom. But essentially what I have done by selecting this is select the record, just like if I had done that on the table. The other thing I want to get rid of, since this will be a scrolling list, are the Record Navigation buttons down here at the bottom. It will be a scrolling list, so I don't need to have this.

Finally, I want this to be a review-only document. I don't want people to be able to go in here, for instance, and start changing data, like renaming people or changing their phone number. I want people just to be able to look at this and not edit the data that's in the underlying data table. So let's make those changes in the Property Sheet. I am going to change the View menu and go back to Design view. I am going to change the Property Sheets for the form. Again the shortcut for that is this button right here between the two rulers and click that so I get this black box here. I can also change to the property of this specific object by using this drop- down menu in the Property Sheet.

Here I can find the listing of every object, including every label inside of my document. I am going to choose Form. Now we're at the Properties for the form itself. The Property Sheet is made up of five different tabs. The Format tab here has options to deal with formatting, including a Caption, which would appear on the tab up here at the top, any kind of Default Views, pictures, borders, colors, scrollbars, and things like that. Let's go through and change some of these. First of all, I am going to change the default view. I will change it from Single Form, and using the dropdown menu here I can change it to Continuous form. And I am actually going to make this little wider so we can see the whole thing. There we go.

So the dropdown said Continuous Forms here. We can change what View modes are allowed. These will control what shows up in the Views button here. So for instance, I have no need to see PivotChart or PivotTable or Layout or Datasheet view; I can turn all those off here in the Property Sheet. So Form view is the standard for interacting with it. I want to make sure I keep that. But for allow Data Sheet view, I will change the dropdown to No. Now instead of using the mouse, you can use your arrow keys to move around. I could use the down key to move down and the up key to move up or if you prefer the right key and the left key to move down and up.

If you prefer left-handed controls, Tab will move you down and Shift+Tab will move you back up. While you are in the left side Ctrl+Tab will cycle through the tabs. Now we could go through and change some things again. I will press Shift+Tab to move up to allow PivotTable view and instead of using the dropdown menu, since I know my only two options are yes or no, I can press N to go to No. I will press Tab to go down a view and again PivotChart View, that one is no as well. Next one down with tab, Layout view, nope, don't want that one either. The next one I want to change is the Record Selectors.

That's about halfway down. So I am going to press Tab a few times until I get to Record Selectors, and it's right there. I am going to turn those to No as well, so I will press N. And right below that there is Navigation Buttons. Those are the ones that appear at the bottom. I am going to change that to No as well. Two more down is Dividing Lines. Since this will be a scrolling from, with each record appearing right on top of itself, I can turn on dividing lines to provide a visual cue where one record ends and the next one starts. I am going to press Y to change that to Yes and press Tab to finalize that. Let's take a look at some of the options in the other tabs. I will switch to the Data tab.

We can use the mouse here to click. The one that I want to take a look at first is this Recordset type. Right now it's set to Dynaset. This is providing the dynamic link between the form and the data table behind it. If I change this here to Snapshot, that will prevent people from being able to edit the data. This will just show a snapshot of the data table as it existed when the person first opened that form. Let's take a look at the next step. I will click on the Event. The Event tab has all the different ways that you can control running macros from your form, so for instance, when a user clicks on something, or down here, if they double-click.

I can trigger a macro when somebody clicks the mouse down and another if they have clicked the mouse up, using these two properties here. There's lots of different ways that you can add interactivity to your forms and reports. Let's look at the Other tab. The Other tab has miscellaneous options. For instance this Pop Up one here, if I change that to Yes, that will make it a floating pop-up window instead of the Tab window. If I change the Modal property to Yes, that will force the user to have to interact and close the form before Access will let you do anything else. And finally, the All tab here has a long master list of every other property in the other four tabs.

So if I can't remember where it is in these other four tabs, you can always come to the All list and find it here. Now let's take a look at the changes that we have made here in the Property Sheet. I am going to up to the View menu and change to Form view. Now you can see it's a scrolling list of all my employees. I can see a slight problem here. I can see that I have got a lot of white space in between each record, so I can go through in Design view and tighten that up a little bit. Go back into Design view. Now scroll down to the bottom here, until I get to the bottom of my form, which is this bar right here, and I will click and I will drag that up little closer to my records.

Now each one will be a narrow view. Back into Form view again and there it is. It's looking pretty good. If I scroll through my employees, we get a nice, continuous rolodex-style list going. So the property sheet is an extensive resource of everything you might want to control in your database, and you will be happy to know that both forms and reports share this common interface. While some of the most common settings can be changed through the Ribbon tabs, the Property Sheet is generally my go-to Resource because it gives access to all of the available settings, not just the most common ones, and often I found the Property Sheet to be a great discovery resource too.

It allows you to find settings and options that you didn't even know you wanted to change until you saw it in the list. Now I am not going to be able to go through all the properties in this course, but I definitely encourage you to scroll through that list and explore it further.

Show transcript

This video is part of

Image for Access 2010: Forms and Reports in Depth
Access 2010: Forms and Reports in Depth

38 video lessons · 14376 viewers

Adam Wilbert
Author

 
Expand all | Collapse all
  1. 1m 27s
    1. Welcome
      1m 2s
    2. Using the exercise files
      25s
  2. 15m 53s
    1. Introducing forms
      2m 41s
    2. Designing for the end user
      45s
    3. Exploring the database
      1m 49s
    4. Creating a form with the Form Wizard
      6m 43s
    5. Refining the form in Layout view
      3m 55s
  3. 24m 33s
    1. Organizing the form elements
      7m 14s
    2. Formatting
      4m 48s
    3. Modifying the form through its properties
      6m 56s
    4. Adding a header and some polish
      5m 35s
  4. 1h 2m
    1. Introducing form controls
      3m 48s
    2. Using lines and rectangles
      2m 48s
    3. Organizing screen space with tabs
      4m 47s
    4. Adding buttons
      5m 3s
    5. Linking to external content
      4m 15s
    6. Entering and selecting data
      5m 8s
    7. Controlling input with option groups
      6m 0s
    8. Attaching documents
      6m 49s
    9. Attaching images
      5m 8s
    10. Understanding the subform control
      4m 13s
    11. Adding charts
      7m 9s
    12. Linking controls
      7m 41s
  5. 21m 42s
    1. Creating the main menu
      8m 49s
    2. Adding a splash screen with startup options
      5m 35s
    3. Creating a customer form
      7m 18s
  6. 45m 20s
    1. Grouping and sorting data
      4m 36s
    2. Understanding report structure
      6m 12s
    3. Building reports from wizards
      5m 0s
    4. Building reports from queries
      6m 34s
    5. Formatting conditionally
      6m 59s
    6. Calculating fields
      4m 35s
    7. Adding the finishing touches
      4m 49s
    8. Populating pre-printed documents
      6m 35s
  7. 15m 8s
    1. Printing reports
      3m 6s
    2. Tweaking the design
      7m 10s
    3. Automating the workflow with macros
      4m 52s
  8. 58s
    1. Next steps
      58s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now "Already a member? Log in

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Access 2010: Forms and Reports in Depth.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

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.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.