Chapter 8, Problem 7AYK

Switch the ClientEntry form to Design view, and expand the Form Footer section to about 75" tall. Add a text box to the top right corner of the Footer section, and enter the formula =Count([ClientID]) as its control source. Enter Total Clients as the label name. (Hint: if necessary, change the width of the label so that the full text is visible). Add another text box directly below the one you just added, and enter the formula =SUM([MonthlyFee]) as the control source and Total Fees as its label name. Modify the Total Fees text box to use Currency format, then switch the ClientEntry form to Form view and confirm it matches Figure 3 below. Save the form. In the italic bold section that is the part I am having trouble with. For some reason the property sheet does not have the Currency Format in there at all. So, I am not sure if I did something wrong or what. Can you help. I am provind an image of the project. In the Total Fees text box is where I am stumped.

.....CAPTION PLEASE DRAW

Delivery Info Next within the form, create a field set with the ID deliveryInfo. Within this field set, add the following: A legend containing the text Delivery Options. A text area box with the ID addressBox and field name of delAddress containing the placeholder text Enter delivery address. A label containing the text Delivery Time (leave blank for earliest delivery) associated with the delBox control. Add an input element with the ID delBox and field name delTime for storing delivery time values. Use a data type of “time” for the control. Pickup Info Next within the web form, create a field set with the ID pickupInfo containing the following information for pickup orders: A legend containing the text Pickup Options. A label containing the text Pickup Time (leave blank for earliest pickup) associated with pickupBox control. Add an input element with the ID pickupBox and field name pickupTime for storing time values. Add the disabled attribute to the tag to disable this control…