Default Value - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Default Value

Mai-Lan Aikens

2 years ago

I have noticed that when I want to use Default Value for currency fields, I cannot enter. Parenthesis right or left. I would like to enter parenthesis for subtotal and tax fields when I am doing a large number of refunds.

	Sami Shamma @Reply 2 years ago
Please be more specific. See Rule #2. Currency can only have numbers. it is a Numeric field. Why would you want to have anything other than numeric value in a currency field?

	Kevin Robertson @Reply 2 years ago
Just make it a negative value. Instead of (1000) use -1000

	Sami Shamma @Reply 2 years ago
Thanks, Kevin, I did not understand what Mai-Lan was talking about.

	Mai-Lan Aikens OP @Reply 2 years ago
What I wanted to do was put parentheses around refund values. Thanks

	Mai-Lan Aikens OP @Reply 2 years ago
Thanks Kevin.

	Kevin Robertson @Reply 2 years ago
Parentheses around negative values is a Windows setting.

	Richard Rost @Reply 2 years ago
In my Account Balances series, I do show you how to enable the ability to type calculations into individual cells, like: `81+1234+12-231` And then use VAL() to calculate the total. I think it's in that series. Somewhere. I know it's in the final database. LOL.

	Sami Shamma @Reply 2 years ago
It is in the Calculator series.

	Kevin Robertson @Reply 2 years ago
It was in also Account Balances 7

	Richard Rost @Reply 2 years ago
Yeah, I knew it was in there somewhere. :)

	Sami Shamma @Reply 2 years ago
I guess watching all the TechHelp videos has its advantages.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View