Home > Support > Hints and Tips > Tip of the Week

Weekly Computer Tip # 115
18 June 2005

Start each week with a free tip

To subscribe, please type your email address in the box below:

Toggle the value in a check box (Microsoft Access)

Last week I did two one-to-one Access training sessions, helping the two participants get more out of their existing database. Both their tables had a so-called Yes/No field, used for fields containing true or false data. (Such as whether or not an invoice has been paid, a person is a union member etcetera.)

Access offers three ways to display data in a Yes/No field (Check Box, Text Box or Combo Box). If you opt for Check Box a check mark indicates a "Yes" entry. I noticed the two trainees were doing this by clicking their mouse in the check box. Nothing wrong with that. But if your mouse is more like a shopping trolley (going anywhere but where you want it to go) it can be a bit of a struggle. So why not use the keyboard instead?

Here's how:

  1. Move your insertion point to the Yes/No field by pressing the [TAB] key.
  2. Press the [SPACEBAR].

Notice a check mark is entered into the field, indicating a "Yes" entry. Press the spacebar again to remove the check mark.

Finally, if you also want to get to grips with effectively using Microsoft Access to create and manage both personal and business databases and use it for your upcoming Christmas card mailout or vital direct mail exercise, check out the new hands off seminar, scheduled for 29 September. (http://www.roem.co.uk/handsoff_access.html) As a weekly tip subscriber you get a 10% discount. But there is more ... Book before 15 July and receive an additional 10% early-bird discount. Pay just GBP197.

Until next week.

Email this page to a friend

Enter recipient's email address in the box below:

PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.

Home   Training   Support   Clients   Contact Details   News   Disclaimer  

© Roem Ltd. All Rights Reserved
June 2005