Currency field question


When building a table and there is a currency field in the General Format and Decimalplaces section I enter Currency and Auto places is this correct or should I put in the format a currency mask or other in format

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick TallaricoDecision Support and Systems AnalystCommented:
I have a tendency to declare the amount of decimals whenever possible, but perhaps that is just a preference.  To guide your user input you could then use the input mask feature to make sure that user input is entered correctly.  Generally this is a good practice when user input is required as opposed to some sort of automated import/export function where the data should already be correct.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chesteraAuthor Commented:

Thank you for that. So and currency Input mak in format is recommended

chesteraAuthor Commented:

What is your thought of the following

Format = $#,##0.00;"-$"#,##0.00
Dec Places = Auto or would you say use 2

IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

Gustav BrockCIOCommented:
It doesn't matter to the values stored in the field.

The format setting is for display only and can be adjusted at any time as to your preference.

However, if you build a form using the wizard, the format of a textbox bound to a field will inherit a format specified in the table or query used as source.

So nothing right or wrong here.

chesteraAuthor Commented:

Thanks for that

Gustav BrockCIOCommented:
You are welcome!

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.