to add the title: Transaction Voucher . Its font size property need be set to with font weight set to bold . Set the fore colour to Blue . (viii) Paste another text box anywhere in the Form and set its Control Source property as = Val(DMax(“Vno”,”Voucher”))+ and Visible property to No.
Further, Set Default value property of Text Box to the left of label Voucher No. as = Val(DMax(“Vno”,”Voucher”))+ . This ensures that the text control generates a new value one more than the preceding value of last voucher number entered in Vouchers table, as and when a new record is added. As a result, the voucher number is detected in Vouchers table and incremented by one to auto generate the voucher number sequentially.
Further, set the Enabled property to No so that the auto generated value is not amenable to any changes by the user. (ix) Set Default value of Text box meant for entering the voucher date as = Now (). This results in giving current RTC date as the default date to voucher as and when a new voucher record is added. Alternatively, click at More Control button in tool box to select Microsoft Data and Time Picker Control, Version .
This control provides a user-friendly and interactive method of selecting a date. Set the format property of this control to “ -dpt custom” and custom-Format property to “dd-MMM-yy” by using DT Picker properties dialog. Control source of this control is set to vdate so that the selected date is stored directly into this field. (x) 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. (xi) Provide for conditional formatting of amount so that its colour turns red as and when an expense voucher exceeding Rs. , is not authorised by an employee whose EmpId =’A001’. This can be achieved by a right click at text box for amount to click at conditional formatting.
A conditional formatting dialog appears in