Working with Text Items

1. Working with Text Items

2. Objectives After completing this lesson, you should be able to do the following : • Describe text items • Create a text item • Modify the appearance of a text item • Control the data in a text item

3. Objectives • Modify the navigational behavior of a text item • Enhance the relationship between the text item and the database • Modify the functionality of a text item • Include Help messages

4. Text Items • Default item type • Interface object for: • Querying • Inserting • Updating • Deleting • Behavior defined in the Property Palette

5. Creating a Text Item Block selection Canvas selection

6. Distance between records Number ofitems displayed Modifying the Appearance of a Text Item Order Item

7. Font and Color Properties Use properties in the Font and Color group to specify an item’s: • Visual attributes • Font name, size, weight, style, color, and pattern

8. Prompts • Prompts specify the text label that is associated with an item. • Several properties are available to arrange and manage prompts. • Use prompt properties of an item to change the prompt’s display style, justification, alignment, color, and font.

9. Associating Text with an Item Prompt 1 3 2

10. Synchronize with Item Property 1 2

11. Id Last Name First Name Title Dept Id 3 Nagayama Midori VP, Sales 31 11 Magee Colin Sales Rep 31 Copy Value from Item Property Dept ORDERS Id Region Id 31 1 Name Sales Employee

12. Format Masks • Standard SQL formats • Dates FXDD-MON-YY • Numbers L099G99D99 • Nonstandard formats Use double quotes for embedded characters "("099")"099"-"0999 Note: Allow for format mask’s embedded characters when defining Width property.

13. Initial Values • Are used for every new record • Can be overwritten • Must be compatible with item’s data type • Use: • Raw value • System variable • Global variable • Form parameter • Form item • Sequence

14. Navigational Behavior of Text Items • Established by order of entries in Object Navigator • Controlled by: • Keyboard Navigable • Previous Navigation Item • Next Navigation Item

15. Database Properties Use properties in the Database group to control: • Item’s data source—base table item or control item • Query, insert, and update operations on an item • Maximum query length • Query case

16. Enabled=No Case Restriction= Upper Justification = Right Justification = Start Functional Properties Order Date 100 Order Id 31-aug-1992 Ordered Date Payment 10-sep-1992 CREDIT Type Shipped Item Id Product Id Price Shipped Item Total 10011 135 500 67,500.00 1 2 10013 380 400 152,000.00

17. Conceal Data Property Log Screen scott Enter Userid: Enter Password: *****

18. Keyboard Navigable and Enabled Properties • Set both properties to allow or disallow navigation and interaction with text item. • When Enabled is set to Yes, Keyboard Navigable can be set to Yes or No. • When Enabled is set to No, the item is always nonnavigable.

19. Multiline Text Items Width Text Text Text Text Height Total text = Maximum length

20. Hint Help Properties

21. Summary • Creating a text item • Modifying appearance • Controlling data • Altering navigational behavior • Enhancing relationship with database • Adding functionality • Including context-sensitive Help

22. Practice 6 Overview This practice covers the following topics: • Deleting text items • Modifying text item properties • Creating text items