answersLogoWhite

0

The field can contain any characters. A maximum number of 255 characters is allowed in a field whose data type is Text.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

What is the default data type in MS Access?

Text is the default data type in MS Access.


Is text an access data type?

No, "text" is not an access data type. In Microsoft Access, commonly used data types include Text, Number, Date/Time, Memo, and Yes/No among others. Text is used to store alphanumeric data such as names or descriptions.


What data type can store up to 255 characters in Access?

Text.Text.Text.Text.Text.Text.Text.Text.Text.Text.Text.


What is data in access?

auto, numbers, text, memo


What is in access data type?

auto, numbers, text, memo


In access 2007 what is the data type you can store a variable amount of text or combination of text and numbers?

Memo


What is a field selector in access?

Text is an example of a data type is that true


What is field selector in access?

Text is an example of a data type is that true


In Access text data type contain maximum character of?

In Access, the Text data type can hold up to 255 characters. If you need to store more characters, you can use the Memo data type, which can store up to 65,535 characters.


What data sources can be linked to in Access?

You can link excel tables, text files, access tables, ODBC tables


What are the data type available for Access table field?

Access Data Types are : Autonumber, Memo Text, Number, Yes/No, date/time, OLE object, Hyperlink, Currency.


What are the Access data types and how they are used?

In Access and in databases in general each field in a database table is of a certain data type. The data type determines what type of data a field can hold. A field of the text data type can hold text, a field of the number data type can hold numbers and a field of the data/time data type can hold date and time values.Access actively checks what type of data is entered into a field and Access will disallow the entry of data into a field that doesn't conform to the field's data type. Access won't allow you to put text into a field of the Number data type, for example.So, data types are a way to restrict the entry of data into a field. Internally, the database uses different strategies for the storage and retrieval of different data types.