Bill-
Thanks a lot.
Best Regards,
Kevin
发自我的小米手机
在 "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年11月24日 上午2:16写道：
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: zhaoliqingoffice <zhaoliqingoffice@163.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar