Tuesday, 28 April 2009

Blanking Stuff on Forms

You have a form. You want the user to do stuff on it but there are some records you need the user to not be able to change. How good would it be to be able to blank those fields so that the user couldn't change them (and, while they're at it, screw the entire database up...)?

Quite easy.
  • Get the form in design view and select the field you want to stop the user changing
  • Click the Properties button
  • Find the Enabled property. It'll say Yes. Bet you can't guess what comes next?
  • Change the enabled property to No (I bet you got that right...)
Now run the form and check it works!

No comments: