Access: Screen Play Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Create ->Table Design Default Date Value The DateSale field can be designed to fill in the date automatically. This would be improve productivity in your busy video store.   Try it: Edit the Field Properties Select the DateSale field. Choose the Format: Short Date Create an Input Mask: Click on the three-dot builder and walk through the Wizard.   Type the Default Value: =Date() This little code enters the current date when the movie are rented.   Save and Close tblReceipt.