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. |