POPUP SPELL NUMBER for Microsoft Access
This utility is a COM add-in or add-in (.mdb) programmed in Microsoft® Visual Basic® for Application (VBA) that makes it possible to capture a number in Microsoft® Access®, configure its respective SpellNumber (write-out number, as in check writing protection) through a popup user interface, and insert it back in Access or send it to the Microsoft® Windows® clipboard to be immediately pasted into any Access place or into another Windows application.
It consists of only one file, the AccessSpellNumber.dll, which is about 160 kb in size and can be installed automatically. Except for the DLL, no another setting is saved in the Microsoft® Windows® Register. Its setting is saved in AccessSpellNumber.ini file that is created and maintained by the proper utility. You can uninstall it totally and automatically, leaving no mess on your Windows Register or disc.
It has multiple settings to fit several ways of spelling fractions. For example:
205.02 (two hundred five dollars and two cents)
- Spells number configuring through a popup user interface. See the pictures below
- Captures number in the selection right-clicked by the mouse, through the SpellNumber command in popup shortcut menu
- If more than one number exists between text in the captured selection, all numbers are duly filtered and listed in the ‘Number’ ComboBox on the interface
- The small interface pops up close to the mouse cursor
- Modal or modeless interface
- With modeless interface, numbers or unit names can be captured by clicking in the Access selection and then on the number or singular unit ComboBox
- The SpellNumber can be sent to Windows clipboard closing the interface immediately or not
- Has a command rose for inserting the SpellNumber above, below, left, right or over the selection and close the interface with only one mouse click. Since, when exiting and inserting, it always copies the SpellNumber to the Windows Clipboard too, an insert can be undone and the SpellNumber immediately pasted in another position
- Moreover can be undone, an inclusion does not break the current undo thread
- A number in the Windows clipboard can be pasted and re-entered as a SpellNumber. If more than one number between exists text, all numbers are duly filtered and listed in the ‘Number’ ComboBox on the interface
- The most recent setting is used as default in the next execution, but the default setting can be restored
- Four options exist for Spellnumber output: without brackets, between brackets; between brackets preceded by the corresponding number formatted according with the unit or vice versa
- Accepts the following hotkeys:
- Hotkey to popup:
Does not exist
- Before inserting and/or sending to clipboard, the user can configure the desired SpellNumber inserting or selecting options listed in the below ComboBoxes of the popup interface.
- Number ComboBox: Cardinal number, with or without fraction, to spell out.
The largest valid number: 1 trillion minus 0.01 (999,999,999,999.99)
- Unit Singular ComboBox: Unit name entry in the singular.
- Fraction Description ComboBox: Entry of options from 1 to 8 for manners of spelling (writing out) the fraction (Optional - Default 3 or 1 if there is UnitNameSing):
Spells the fraction in cent/cents. Ideal for coins
- Letter Case ComboBox: Entry of options from 1 to 4 provides choices for formatting letters in upper/lower case:
1 - all lower case
- If you need more options to configure your numbers correctly, you can click the ‘More options’ button to make the ComboBoxes below available:
- ‘One thousand’ ComboBox: Entry of the options for spelling out 1000, either omitting 'one' or not:
True (Yes, 'one thousand') or False (Not, 'thousand').
- Thousand comma ComboBox: Entry of the options for comma intercalation between thousand or not:
True (Yes) or False (Not);
- Unit Plural ComboBox: Unit name in the plural (Optional - In the lack the pluralization will be done automatically from unit name in singular, thus this only is necessary when the desired plural diverges from the language default as defined in the code).
- Occupies less than 150 Kb when installed.
Tested in Microsoft Access 2000, 2002(XP), 2003, 2007, 2010 (32-bit), 2013 (32-bit), and 2016 (32-bit) in MSI-based and Click-To-Run installations of Office 365™ cloud-based services.
Note: The above link downloads the installer and uninstaller package programmed in VBA in a MDB duly converted to EXE by the DBtoEXE to make the installation easier for macro and Windows laymen; however, if you're an expert and for some reason prefer an installer and uninstaller package in open ZIP format, click here. With this zip package you can install it in three ways: (1) Simply initiate the Install.exe that loads the same MDB in Access without macro alert; (2) Extract the entire package to a folder and initiate the MDB, enabling the macros in Access and using 123 as password, or (3) Install the DLL manually.