Memo Fields

To accommodate multiple line fields that contain more than 254 characters, Monarch includes support for memo fields which can handle up to 65,536 characters (64KB).

Let’s change the field type of the Remarks field to Memo.

Steps:

1.    Select Table Design to launch the Table Design interface.

2.    In the field list that displays, locate the row for Remarks and then change its type to Memo.

3.    Select Accept  to accept your changes and return to Table view.

The Remarks field is redisplayed as a memo field.

To view more information for each memo field, you’ll have to adjust the height of each row. Let’s try doing this now.

4.    In the left hand side of the Table view, click on the border between Rows 1 and 2, then drag down to expand the height of the rows to at least six lines.

Even using a row height of 6 lines, we still may not be able to see all of the text in some of the Remarks fields. To view more information, we could increase the width of the field, but this may still not allow us to view the entire contents of each cell. Although we could adjust the row height again (Monarch allows a maximum row height of 12 lines), let’s try something new instead. Let’s give Monarch’s Show Field Contents feature a try, which displays the entire contents of a cell.

5.    Select Show Field Contents  from the Table ribbon.

Monarch opens a small window at the top of the display. This window, called the Field Contents window, displays the entire contents of the selected table cell. Initially, the window height is only a few lines, but you can increase the height to show more lines and you can scroll within the window to view the entire contents of a cell.

As you move the cell pointer from cell to cell in Table view, the Field Contents window will display the contents of the selected cell. You can try this by using the down arrow key on the keyboard to scroll through the Remarks field cells.