|
Navigation: Main Menu > Tools Menu > Database and Forms > Edit Contact Details Form > Quick Reference Table |
![]() ![]()
|
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).
COMMON USES |
DATA TYPE TO USE |
|
Standard Text /Characters up to 255 |
||
Label, Caption, Title |
DataField type not necessary |
|
Phone Number |
||
Website URL, Email, Skype ID |
||
Date |
Date or Date & Time |
|
Time |
Date, Time, or Date & Time |
|
Tabs, Pages box (such as multiple mailing addresses) |
DataField type not necessary |
|
Documents, Files, Links to Files |
||
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 |
|
Multi-line Text, lists |
||
Numbers/Integers with no decimal places which will be used in calculations |
||
Numbers with decimal places, Currency |
||
List, String List, Drop Down List, Select From |
Usually String but could be others |
|
Multiple pages/tabs for groups of data (ex. address 1, address 2) |
DataField type not necessary |
|
Phone numbers box, email addresses box, etc... |
DataField type not necessary |
|
Fixed text edit box - company name, address, phone numbers (items that can change but you only want to change once within the database) |
any |
|
Personal wave file recording for each contact |