Microsoft access updating
You can enter only currency values in this type of field.
Also, you do not have to manually enter a currency symbol.
Instead, a typical Access database is a a collection of tables, plus a set of objects built around those tables — forms, reports, queries, and so on.
In addition, those objects must adhere to a set of design principles or the database will either work poorly or fail altogether.
By default, Access applies the currency symbol ( ¥, £, $, and so on) specified in your Windows regional settings.
See the Attachment entry, later in this table, for more information.View data types by using commands on the Datasheet tab The data type set for each table field provides the first level of control over what you can and cannot enter into a field.In some cases, a data type setting prevents you from entering any information at all.For more information about using rich-text formatting in a Memo field, see the article Format data in rows and columns.Like Text fields, you can also run conversion functions against the data in a Memo field.