Free Check Writer for Microsoft Access Templates

Building a custom Check Writer in Microsoft Access is an excellent way to automate your accounting workflow. The project relies primarily on two components: a data entry form to manage your transactions and a meticulously aligned report configured to match your physical check stock.

The exact process varies depending on whether you are using pre-printed check stock or blank check paper. Scenario A: Using Pre-Printed Check Stock

If your check paper already features your company name, bank details, routing number, and account number, your goal is simply to overlay text precisely onto the empty fields. 1. Define the Data Structure (Table)

Create a base table named tblChecks with fields designed to mirror a physical check register: CheckID: AutoNumber (Primary Key) CheckNumber: Short Text CheckDate: Date/Time Payee: Short Text Amount: Currency Memo: Short Text IsPrinted: Yes/No (helps track unprinted queue) 2. Create the Data Entry Form

Use the Form Wizard or Form Design view to create a simple user interface (frmCheckEntry) based on your table. Add a command button to the form to trigger the print sequence for the active record. 3. Build the VBA “Number-to-Words” Converter

The primary hurdle is translating a numerical value like $123.45 into text (“One Hundred Twenty-Three and ⁄₁₀₀”). Access does not natively have this function, so you must add custom VBA code: Press ALT + F11 to open the VBA Editor. Click Insert > Module.

Paste a standard English Number-to-Words (SpellNumber) function. (Microsoft provides an official SpellNumber function script via their documentation that can be copied directly). Save the module as modSpellNumber. 4. Build and Align the Report Check Writer & Printer – Download and install on Windows