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 ‘ *’ . Click colour icon to select red colour in condition- .
Click OK to close the conditional formatting dialog. (xii) Control morphing from Text box to List box is to be applied on four-text control, each one meant to store Debit, Credit, AuthBy and PrepBy. This can be achieved by right click at each of these controls one by one and click at Change To item of right click window. To begin with, select List Box option for text box next to Label Debit .
Height of text box is expanded. Re-size, it to its original shape and right click to select the property window. Select Data properties button to provide the Row Source as Account table. Click at format properties button to set the column count property to and column width property to .
" . Ensure that the width property of list control for debit is set to a minimum of . ” to accommodate the code as well as Name of Account in a row of list control. The process can be repeated for Text boxes next to Credit.
Text controls meant for AuthBy and PrepBy can also be morphed into List Box controls in a similar way, except that the Row Source Property should be Set to Employees table and Column width be set to . ” only because occupies only four text spaces as opposed to Account code, which need six spaces. Width property of these list controls can be suitably adjusted to accommodate both EmpId and Fname of employees authorising or preparing a voucher. (xiii) Paste List Controls for selecting debit and credit Accounts on the Right Hand Side (RHS) of Voucher Form.
Following steps are taken to accomplish this : Click at list box control available in tool box and carry the mouse pointer to the right side of the Form. Its shape will turn into a cross with icon of list control. Place it at