Solved

Currency field question

Posted on 2012-03-29
6
324 Views
Last Modified: 2012-03-30
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
0
Comment
Question by:chestera
  • 3
  • 2
6 Comments
 
LVL 6

Accepted Solution

by:
Patrick Tallarico earned 250 total points
Comment Utility
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
 

Author Comment

by:chestera
Comment Utility
stpmt11

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

Alan
0
 

Author Comment

by:chestera
Comment Utility
stpmt11

What is your thought of the following

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

Alan
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 49

Assisted Solution

by:Gustav Brock
Gustav Brock earned 250 total points
Comment Utility
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
 

Author Comment

by:chestera
Comment Utility
cactus_data

Thanks for that

Alan
0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
You are welcome!

/gustav
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now