O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data Protection on Forms

You can protect individual fields on a form from changes if you like. For instance, I might protect the AKC Registration # field in my Kennel database from changes, so I don't accidentally overwrite these important numbers.

To protect a field on a form:

  1. Open the form in Form Design view.

  2. Right-click on the field and select Properties.

  3. Click on the Data tab.

  4. Change the Locked property to Yes (see Figure 28.2).

  5. Close the Properties box.

    Figure 28.2. Protect an individual field on a form by locking it.

You can protect an entire form from changes, making it "read-only." For instance, if you kept your company's work schedule ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required