When you are placing column or variable objects with a NOTE data type, you can make the object location smaller than the actual length of the text you will be entering and yet enter as much text in the field as the column length allows. The objects can be placed as a single line object or a multiple-line scrolling object.
We will place the Place column as a multiple-line scrolling object called a DB Memo object. The column has a NOTE data type and can hold as many as 4,050 characters. The salesperson can enter as much information as necessary in the field.
To place a DB Memo object on FlightForm:
| 1. | In the "Form Designer" window, choose "DB Memo" button from the "Database Controls" toolbar. |
The "DB Memo" button has a piece of paper with multiple lines on it with a database cylinder in the image foreground and is the third button from the top left.
| 2. | Position the cursor toward the bottom of the Form Designer workspace and click the left mouse button. Refer to the sketch of the form as needed for object placement. |
The "DB Memo Properties" dialog box is displayed.
| 3. | From the "Table and Field" panel, choose Place from the "Data Field" drop down box. |
| 4. | Make sure that the "Word Wrap" option in the "Attributes" panel is checked. |
Across the top of the dialog, there are more tabs for additional properties.
| 5. | Choose the "Effects" tab. |
| 6. | From the "Scroll Bars" panel across the bottom, select the "Vertical" radio button to add a vertical scroll bar. |
| 7. | Click the OK button. |
The column object is placed with the default width.
| 8. | Click on the handlebar on the lower right corner of the Place object and drag it to the right to increase the size of the box for several lines of text to wrap. |
With the "Word Wrap" attribute, the text will wrap at the end of each line. When the text reaches the end of the last line of the box, the top line will scroll out of sight leaving an empty line at the bottom of the field.
When running the form, you can display all the data by double clicking in the DB Memo field to launch the R:BASE BLOB Editor. The R:BASE BLOB Editor can be used to view and edit the text of NOTE and VARCHAR data type columns. It can also be used to view and edit images.
If you have not done so already save the form. From the menu bar, choose Form: Save Form.
