You can customize your data appearance on the add/edit/advanced search pages using formatting options on the "Edit as" settings dialog. To control the filed appearance on the page click right button over the field and choose Properties. Depending on selected format you will see different box-dialogs.

Fields format you've chosen is preserved on the Advanced search page, for example, drop-down boxes, date-pickers, checkboxes formats. Apart from this, search is now case-insensitive.

Text field

Simple text box.

See list of available validation types here.

Default value

Now() - current datetime.

Session("UserID") - user id of person who updated the record.

Request.ServerVariables("remote_addr") - IP address.

Apply on the Edit page as well

If you check off this check box default value will be applied every time record is updated. You can use this feature to keep track of who and when updated the record.

Text area

Mutlitrow text area. For advanced WYSIWYG edit capabilities check off Use Rich Text Editor checkbox.

More info about using Rich Text Editor.

Password

Password field. All entered characters appear as "*".

Date

Date edit control. You can choose between simple edit box, simple edit box with datepicker, drop-down boxes with day, month and year selection, and advanced datepicker.

Simple edit box with datepicker also allows to enter time.

Time

Time edit control. You can select Use Time picker checkbox and enable time picker to select time instead of typing it. Select 12 or 24 hour format and one of available minute intervals.

Radio-button

Use a radio button control to limit a user's selection to a single value within a set of values.

Checkbox

Checkbox control. Works best with the following datatypes:

File/Image

Depending on field type this control allows to upload images and files to the database (binary field) or to some directory on the Web server (text field).

To upload images and files to some directory on the server, you need to enter the path to that directory. The path should be relative to the folder with generated pages. Since some hosting providers do not allow making reference to the directories, which are above the current one, you can use the Absolute path option and specify the full path to the directory on the server, in which files will be uploaded. E.g. C:\Inetpub\WWWROOT\project1\files.

Use the Add timestamp to filename option to add the date/time to the filename so that each file has the unique name. Use the Delete file when associated record is deleted option to make sure that a file will be deleted when associated record is deleted from the database. This option is global and if enabled is applied to all tables and fields.

ASPRunnerPro allows creating thumbnails on the fly. If you want to do this then you should select the Create thumbnails of the fly checkbox and:

Binary field - choose thumbnail size and the field name in which the thumbnail will be saved.

Text field - choose thumbnail size and thumbnail prefix.

For example, if the original image file's name is example.gif and thumbnail file's name is th_example.gif correspondingly then the thumbnail prefix should have the value of "th_".

Note: To work with thumbnails you need to have ASPJpeg component installed on the Web server. Most Web hosting companies have this component installed.

To resize images on upload check off Resize images after upload option and select max width or height of resulting image.

Lookup wizard

Drop-down box with list of values. More info about lookup wizard.

Readonly

Use this format for a field that should not be edited.