wizard responds by prompting the designer to enter the default option. (vii) Select Debit so that by default, the compound voucher is a Debit Voucher. Click at Next button. Access responds by prompting the designer to enter the data values corresponding to each of the option labels.
Enter against Debit and Credit and respectively. Click Next button. (viii) Access Responds by requiring the user to either opt for Save the value for Later Use or Save the value in this Field . Choose the second option for Save the value and select Vno as Type field.
Click at Next button. (ix) Access responds by asking the designer to choose the appropriate control type. Choose Option buttons, along with any of the styles given below in wizard dialog. Click Finish button.
Access assigns a default label to the Option group. Select the label by right clicks and remove it by clicking at Cut . (x) Click at text control in tool box and add it to the centre top of the Form to provide a dynamic text for the title: Debit or Credit Voucher . The attached label control is removed by a right click on this label followed by a click on Cut .
The font size property of Text need be set to with font weight set to bold. Set the fore colour to Blue. Set its Control Source property as = IIF([Type] = ,”Debit”,”Credit”) & “ “ & “Voucher” Re-size the width of this text control so that it can accommodate and display the dynamic title of voucher. By entering the above formulae in Control Source property, text control for title becomes dynamic.
Whenever, the Type field is assigned value, a text control for title displays Debit Voucher and when the value of Type is set to , the Credit Voucher is displayed by the this Text control. The title of simple Transaction Voucher is static. Therefore, a label control has been used for this purpose. Further, set the Enabled property to No so that the displayed text is not amendable to any changes