2.0
Table Of Contents
- Introduction
- Installation and Setup
- Tutorials
- Views and Form Usage
- OmniForm Procedures
- Designing a Form
- The Design Process
- The Design View Toolbars
- Creating Objects
- General Creation Guidelines
- Creating a Text Object
- Creating a Line Object
- Creating an Oval Object
- Creating a Rectangle Object
- Creating a Graphic Object
- Creating a Fill Text Object
- Creating a Comb Object
- Creating a Check Box Object
- Creating a Circle Text Object
- Creating a Table Object
- Creating a Fill Graphic Object
- Defining Objects
- Changing Object Appearance
- Redesigning Your Form
- Using the Scrapbook
- Inserting OLE Objects in a Form
- Filling a Form
- Managing an OmniForm Database
- Using Calculations
- Calculation Overview
- Operators
- Functions
- Abs (Absolute Value)
- Avg (Average)
- Date (Current Date)
- DayName
- DayOfMonth
- DayOfWeek
- DayOfYear
- Exp (Exponentiation)
- FV (Future Value)
- Hour
- If
- Int (Integer)
- Left
- Length
- Ln (Natural Logarithm)
- Log (Base 10 Logarithm)
- Lower
- Max (Maximum)
- Middle
- Min (Minimum)
- Minute
- Mod (Modulus (Remainder))
- Month
- MonthName
- Pi
- PMT (Payment)
- Position
- Proper
- PV (Present Value)
- RecordCount
- Replace
- Replicate
- Right
- Round
- Second
- Sign
- Sqrt (Square Root)
- Sum
- Time
- Trim
- Trunc (Truncate)
- Upper
- Year
- Functions — Quick Reference
- Functions Sorted by Type
- Technical Information
- Glossary
Tutorial 3 — Design Your Own Form
Tutorials - 57
Calculate Profit
Profit, on this form, equals the Earnings minus Expenses. You will create
this calculation manually instead of using the Calculation Builder dialog
box so you can see another feature of OmniForm.
1 Select the Profit fill text object.
2 Click in the calculation toolbar’s text box to activate the toolbar.
Your cursor turns into a calculation cursor.
3 Click the Earnings fill text object in the form.
The field name appears in the calculation toolbar.
4 Click in the calculation text box after
[Earnings]
and type a
subtraction (-) sign.
5 Click the Expenses fill text object in the form.
The calculation in the calculation text box should now read:
[Earnings]-[Expenses]
Click the Cancel Calculation button in the calculation toolbar if you
make an error to clear the text box and start again.
6 Click the Accept Calculation button in the calculation toolbar to
define the calculation on the
Profit
field
.
7 Click the Calculation button in the standard toolbar or choose
Calculation...
in the Tools menu to close the calculation toolbar.
Customize the Form
Format Objects
As a general rule, forms are easier to read if you use the same font format
for all the text objects. Point size and style can be varied according to
what you decide looks best and is most logical for the form you create.
On the form shown on page 39, all text objects are 9-point Arial bold
with the exception of the text objects under
Job Type.
These four objects
are entries under a header and it could be confusing if they had the same
formatting as the header.
See “Format Text” on page 26 for information on using the
Select
Special...
command. See “Formatting Text” on page 155 for detailed
information on changing text and font attributes.