Memo Fields and Text Fields

[Nessa]

Hello I posted a message yesterday about this

I tried changing the text field to a memo field but it
keeps telling me that the maximum number of charadcters
allowed is 255. What can i do?

Help?

I'm using Access 2002

Thankies!
Nessa

 

[John Vinson]

Hello I posted a message yesterday about this

I tried changing the text field to a memo field but it
keeps telling me that the maximum number of charadcters
allowed is 255. What can i do?

Don't Sort or Group By the memo field.

 

[Shao]

The problem with Access is that sometimes when you change
something in the tables, the forms might not pick it up.
Maybe this will improve in later versions. I am assuming
you are running into the 255 char limit problem in your
form. Just delete the problem text box, then drag the
field from the field list you want back to the form. This
should fix it. Hope this helps.