Lesson3.9.Freezing a Field


Lesson 3.9. Freezing a Field

Figure 3-17. Freeze a field by right-clicking the field name and selecting Freeze Columns from the shortcut menu.


Figure 3-18. Information in the frozen field remains on the screen as you scroll and move through the table.


Most tables have so much information that it won't all fit on the same screen. When this happens, you have to scroll through the datasheet to add, delete, modify, and view information. The problem with scrolling and viewing information in a large table is that it can be confusing when you can't see such important information as names or product numbers.

To overcome this problem, you can freeze a field so it stays in the same place while you scroll around the rest of the table.

  1. If it isn't already open, open the Employees table.

    Here's how to freeze a field.

  2. Right-click the Last Name field name and select Freeze Columns from the shortcut menu, as shown in Figure 3-17.

    The Last Name field is now frozen and will always remain visible as you move through the rest of the table. Try scrolling the table window to see for yourself.

  3. Scroll the table to the right to view all its data.

    Notice how the frozen Last Name field stays on the screen as you scroll the table, allowing you to always be able to see the last name for each record, as shown in Figure 3-18. Now you're ready to unfreeze the Last Name field.

  4. Select Format All the fields in the table are now unfrozen.

    QUICK REFERENCE

    TO FREEZE A COLUMN:

    • RIGHT-CLICK THE COLUMN FIELD NAME YOU WANT TO FREEZE AND SELECT FREEZE COLUMNS FROM THE SHORTCUT MENU.

    TO UNFREEZE A COLUMN:

    • SELECT FORMAT




CustomGuide Inc - Access 2003 Personal Trainer
Access 2003 Personal Trainer (Personal Trainer (OReilly))
ISBN: 0596009372
EAN: 2147483647
Year: 2005
Pages: 209

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net