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
Defining Objects
Designing a Form - 141
Set Validation Options
1 Click the
Validation
tab.
2Select
Must be Filled in
to display a prompt in fill view if the
user does not fill the field.
The
Can Be Filled
option in the
Filling
tab, when deselected, overrides
the
Must be Filled in
option when it is selected.
3Select
Data Must Match Field Type
to display a prompt in fill
view if the user enters incorrect information in the field.
If the field type is
Number,
for example, the user cannot enter
text in the field;
5
is acceptable but
five
is not.
4 Select an option under
Number Checking
to display a prompt in
fill view if a user enters numbers outside the set range.
Number Checking
is enabled when
Number, Currency,
or
Percentage
is the selected type in the
Properties
tab.
•Select
Lowest Number
and enter a number in the text box.
Numbers entered in the selected field must be equal to or
greater than this number.
•Select
Highest Number
and enter a number in the text box.
Numbers entered in the selected field in fill view must be
equal to or lesser than this number.
5 Click
OK
to apply the changes and close the dialog box.