POPUP SPELL NUMBER for Microsoft Access
This utility 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 Windows clipboard to be immediately pasted into any Access place or into another Windows application. It is programmed in Microsoft® Visual Basic® for Application (VBA) and optionally available as COM Add-in (dll), EXE Add-in (xla/exe), or Add-in (xla), may be useful for Access interface user and VBA programmers. See the pictures below.
It consists basically of only one file (AccessSpellNumber.dll, AccessSpellNumber.exe, or AccessSpellNumber.mda) that can be installed automatically using one of the installer package files available below to download. Except for the DLL, if you choose COM Add-in, no other setting is saved in the Windows Register. Its setting is saved in AccessSpellNumber.ini, and AccessSpellNumberLoadExe.mda files that are created and maintained by the proper utility. You also can uninstall it 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)
Following items in this page:
- 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 and 64-bit), 2013 (32 and 64-bit), 2016 (32 and 64-bit), and 2019 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365™ cloud-based services.
This utility can be available to be installed in three options of add-ins: EXE Add-in, COM Add-in, or Access Add-in. COM Add-in and Access Add-in run on Windows in the same process or memory space of Access and are well detailed technologies in Access documentation and good books about VBA, while EXE Add-in is a special name here for a mix of those two technologies where the same VBA code is run in separate EXE process and a small Access Add-in makes the connection between the two processes. Despite the differences in the technologies, this utility is fully functional in any of them. So, what can decide on your choice to install are the features below compared: