Hi Kevin,
each time you pick Currency for Data Type, Access sets the format based on your Windows Region settings.
However, as Bill said, you should be able to change just the format ... and it should stick! I do this too ...
> "How can I turn off the money sign forever"
by going to the Control Panel and to Region and setting the format there.
warm regards,
crystal
Popup a PleaseWait form
http://www.rogersaccesslibrary.com/forum/popup-a-pleasewait-form_topic591.html
~ have an awesome day ~
On 11/23/2015 11:16 AM, wrmosca@comcast.net [MS_Access_Professionals] wrote:
That's one of my big gripes with Access...the auto formatting of currency fields. I set a field to Currancy data type and set the format to fixed and it held. Maybe if it is an existing field with data already in it you will have to create a new field, set the format and then move the data to the new field.
Or you can change it to a number (decimal) and set the number of decimal places to 2 (or 4 if you want to comply with banking standards).
---In MS_Access_Professionals@yahoogroups.com, <zhaoliqingoffice@163.com> wrote :
Dear All,
I set a currency field to fixed format with two decimals in table designing. When I saved the table and open it again, it returns back to currency with default system dollar sign again. How can I turn off the money sign forever.By the way, I need the two decimals remained. Thanks in advance.
Best Regards,
Kevin
__._,_.___
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar