J-Walk Enhanced Data Form v2


Return to The Spreadsheet Page

Enhanced Data Form Home

Features

How to use it

Customizing the Data Form

FAQ

Free download

Purchase VBA password

 

Features

The table below compares the J-Walk Enhanced Data Form with Excel's built-in Data Form.

Feature J-Walk
Enhanced Data Form
Excel's Built-In
Data Form
Maximum number of fields (columns) Unlimited 32
Sizable Yes. You can specify the height and width. If the size is too small, the dialog box fields will scroll. Sizes automatically, based on the widest column and number of fields. In some cases, the dialog box may be larger than the entire screen!
Highlights the current record in the worksheet? Yes. This makes it very easy to see the actual record you are editing. No
Option to display fields as either a Text Box or a drop-down Combo Box? Yes. This makes it possible to choose data from a list of items. No, all data is displayed in a Text Box.
Displays the current record at start-up? Yes No. Always displays the first record.
Selects the current record when the form is closed? Yes No. The worksheet selection is not changed.
Allows insertion of a new record at any row position? Yes No. New records are always appended to the end of the database.
Undo available? Yes Limited
Language customization? Yes. Those who purchase the VBA password can easily change the text displayed in the Data Form. No
Handles the apostrophe "prefix character" correctly? Yes No. For example, editing a 16-digit credit card number preceded by an apostrophe will cause the credit card number to be converted to a value (with one digit lost).
VBA source code available for customization or learning purposes? Yes, for a nominal fee. No. Excel's Data Form is not written in VBA.