Navigation:  Main Menu > Tools Menu > Database and Forms > Edit Contact Details Form >

Quick Reference Table

Previous pageReturn to chapter overviewNext page

See Also: Opening the Form Editor; Create New Form; Quick Reference Table for Controls and Data Type; Add Field; Controls; Data Types

Quick Reference for Controls and Data Types to be chosen for common Field types:

(Click Topic to view more info.  Click Back button to return to here).

CONTROL

COMMON USES

DATA TYPE TO USE

Text Edit

Standard Text /Characters up to 255

String

Text Label

Label, Caption, Title

DataField type not necessary

Dialer

Phone Number

String

Hyperlink

Website URL, Email, Skype ID

String

Date

Date

Date or Date & Time

Time

Time

Date, Time, or Date & Time

Page Box

Tabs, Pages box (such as multiple mailing addresses)

DataField type not necessary

File Link Box

Documents, Files, Links to Files

Memo

Image

Image - part of form and not modifiable except in edit mode w/ Form Editor

DataField type not necessary-any graphic type will work - insert image via Picture property

DB Image (database image)

Image - linked to each contact in database

Image

Memo

Multi-line Text, lists

String or Memo

Number

Numbers/Integers with no decimal places which will be used in calculations

Number

Number

Numbers with decimal places, Currency

Currency

Combo Box

List, String List, Drop Down List, Select From

Usually String but could be others

Page (Tabs) Box

Multiple pages/tabs for groups of data (ex.  address 1, address 2)

DataField type not necessary

Group Box

Phone numbers box, email addresses box, etc...

DataField type not necessary

DB Text Label

Fixed text edit box - company name, address, phone numbers (items that can change but you only want to change once within the database)

any

Edit Wave

Personal wave file recording for each contact

String