Field Size in Design View

[fencie3]

Hi,

May I know how to write the field size which is more than 255 in design view?

Thanks.

 

[Galaxiom]

The content of Text fields is limited to 255 characters in any view.

Use a Memo datatype for longer content.
http://office.microsoft.com/en-us/access-help/insert-change-or-delete-a-memo-field-HA010096313.aspx

 

[John Big Booty]

You could use a memo field instead of a text box which will give you a limit of 65,535 charters, if entered through the user interface; 1 gigabyte of character storage when entering data programmatically.

 

[fencie3]

Hi,

If let say a question is asking, please enter the field which is more than 255?

Is it I should write > 255 in the format?

Thanks

 

[Galaxiom]

?????????????

In the Design View of the table choose the field and change the Data Type to Memo.

 

[fencie3]

Hi Galaxiom,

Sorry I am confused.

Anyway, thanks for clarify as I am new user.