The table below compares the J-Walk Enhanced Data Form with Excel's built-in Data Form*.
Enhanced Data Form 3
|Works with any database table in any worksheet||Yes||Yes|
|Available in the Excel 2007 Ribbon||Yes, in the Data tab||No. But it can be added to the Quick Access Toolbar.|
|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.
In addition, the user can drag the lower right corner to size the dialog box.
|Sizes automatically, based on the widest column and number of fields. In some cases, the dialog box may be larger than the entire screen!|
|Change the width of the field labels||Yes||No|
|Highlights the current record in the worksheet?||Yes. This makes it very easy to see the actual record that 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.|
|Language customization?||Yes. Those who purchase the VBA password can easily change the text displayed in the Enhanced 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.|
* In Excel 2007, Microsoft does not include a direct way to access the built-in data form. To use the built-in data form you must add an icon to your Quick Access Toolbar. Right-click the QAT and choose Customize the Quick Access Toolbar. Then choose Commands Not in the Ribbon from the listbox, and and click Form. Click the Add button to add the icon to your QAT.