Currency field question

Hi EE

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

chestera
chesteraAsked:
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 TallaricoFSEP 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.
0

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:
stpmt11

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

Alan
0
chesteraAuthor Commented:
stpmt11

What is your thought of the following

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

Alan
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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.

/gustav
0
chesteraAuthor Commented:
cactus_data

Thanks for that

Alan
0
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
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.