paste SubForm control for creating a grid to accommodate the Debit/Credit Entries. SubForm wizard gets activated and displayed. Choose existing Tables/Queries, followed by click at Next button. Subform wizard displays a dialog to giving fields classified by their respective tables.
Choose Sno, Code from VouchersDetail table; Name from Accounts table; again Amount, narration and Vno from VouchersDetail table. Click Next button. (ii) Choose “Show VoucherDetail for each record in VouchersMain using Vno” and Click Next and provide the name for subform object as “VouchersDetail SubForm” Click at Finish . The SubForm stands created to accommodate the data contents in voucher grid.
The attached label of SubForm is removed to pave the way for creating dynamic title. This is achieved by adding another text control (remove the attached label control) at the top of the SubForm in the same manner as applies to the title of voucher, except that the Control Source property is set to = IIF([Type] = ,”Debit”,”Credit”) & “ “ & “Entries ” . This calculated control is capable of showing the title of the grid as Debit Entries or Credit Entries, depending on choice of Option button at run time. The Voucher number column in grid can be hidden by merging its right most vertical line with vertical line separating narration and voucher number column by drag and drop method.
(iii) Set the format property of Text box meant for Amount to Standard with decimal places to . This ensures the appearance of amount up to two decimal places with standard punctuation of numeric values. (iv) Provide conditional formatting of amount so that its colour turns ino red as and when an expense voucher exceeding Rs. , is not authorised by an employee whose EmpId =’A001’.
This is achieved by a right click at text box for amount to get short-cut window so that conditional formatting item is selected. A conditional formatting dialog appears in which condition- is to be given as “Field value greater than Rs. , ” interactively. Click Add button to provide condition- as Expression is [AuthBy]<>’A001’ and [Debit] like ‘ *’ .