Share this Page URL

Chapter 3. Managing the Consistency, For... > Using an Input Mask to Manage Data E... - Pg. 90

Managing the Consistency, Format, and Integrity of Your Data 4. 5. 6. In the Field Name column, select the fields you want to include in the index. In the Sort Order column, select the order in which you want to sort records. Close the Indexes dialog box, and save the changes to the table's design. 90 Other Field Properties You'll notice a few other field properties in the Table Design window, including Unicode Compres- sion, IME Mode, and IME Sentence Mode. If you're creating a database that will contain large amounts of text, you should learn more about the Unicode Compression property. In essence, set- ting this property to Yes (which is the default value in fields with the Text, Memo, or Hyperlink data type) automatically compresses the data in the fields, if necessary, so that they require less storage space. The Access online help has more information about this property. The IME Mode and IME Sentence Mode properties are related to East Asian languages. IME stands for Input Method Editor, which is a program that's used to convert keystrokes into complex East Asian characters. The Access online help also has more information about these properties if you need to use them in your database. We'll look at the SmartTag property in Chapter 13, "Completing Your Database Application." Quick Check Q. Where does the text you enter in the Caption property appear? A. It appears by default as the text in the label when you include the field on a form or a report. Q. What criteria should you use to index a field?