Specifications

CHAPTER 20 Enhancing Forms
Users Guide 565
For more information about the functions you can use in computed fields in the
Form painter, see Chapter 24, “DataWindow Expression and InfoMaker
Functions” and online Help.
Adding pictures to a form
You can place pictures, such as your company logo, in a form to enhance its
appearance.
Tips for using pictures
To display a different picture for each row of data, retrieve a column containing
picture file names from the database. For more information, see the section on
character columns in “Specifying additional properties for character columns”
on page 90.
To compute a picture name when a form is run, use the
Bitmap function in the
expression defining a computed field. For information about the
Bitmap
function, see Chapter 24, “DataWindow Expression and InfoMaker
Functions” and online Help.
❖ To add a picture to a form:
1 Click the Picture button in the Controls drop-down toolbar, or select
Insert>Picture from the menu bar.
2 Click where you want the picture to display.
The container for the picture displays in the Layout view.
3 In the Properties view, enter a file name in the File Name box, or click the
Browse button next to the FileName box to display the Select Picture
dialog box and navigate to find the picture file.
The picture must be a BMP, RLE, WMF, GIF, or JPEG file.
Monthly salary if Salary column contains
annual salary
Salary / 12
Four asterisks if the value of the Salary
column is greater than $50,000
IF(Salary> 50000, "****", "")
Average salary of all retrieved rows Avg(Salary)
Count of retrieved rows, assuming each
row contains a value for EmpID
Count(EmpID)
To display Enter this expression