Hi, I looked at the list of all the questions for Expert 8, but no one else has this issue. I double checked the format for the GrandTotal text box we copied, and it says its currency, but it doesn't show as currency on the form. The other two text boxes show the $ symbol, but not the Grand Total. I double and triple checked to make sure I typed in the formula(?) correctly, and it matches the video. I saved; closed; reopened; then closed Access and restarted. Other than rebooting my computer, I don't know what else to do. I know it's not a big deal, but I'd like to know if I'm doing anything wrong. Help?
Sharon SplinterOP
@Reply 4 years ago
Kevin Robertson
@Reply 4 years ago
Can you post a screenshot of the Property Sheet for the Grand Total.
You could use the Format function:
=Format([SumExtPrice]+[SumSalesTax],"Currency")
Sharon SplinterOP
@Reply 4 years ago
Thank you! The format function worked.
Kevin Robertson
@Reply 4 years ago
You're welcome.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 8.
