By default, Access applies the currency symbol ( ¥, £, $, and so on) specified in your Windows regional settings.When you click a field that is set to this data type, Access displays either a check box or a drop-down list, depending on how you format the field.You use this type of field when you want to display data from a file created in another program.
You can enter any data in this type of field, and Access wraps it in a Web address.For example, if you type a value in the field, Access surrounds your text with Uniform Resource Locator (URL) text, like so: Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature.As you proceed, remember that updating data is not the same process as entering new data.The following table lists the data types that Office Access 2007 provides and describes how they affect data entry.
Text fields accept either text or numeric characters, including delimited lists of items.
You can enter large amounts of text and numeric data in this type of field.
Also, if the database designer sets the field to support rich text formatting, you can apply the types of formatting that you normally find in word processing programs, such as Office Word 2007.
You can use the commands on the Datasheet tab, or you can open the table in Design view.
The following sets of steps explain how to use both techniques.
You can enter only currency values in this type of field.