Problems with MS Access field size

  emikretep 09:37 23 Feb 2005

I am having probs with increasing the field size on a data base I have designed.
Normally, the field is set to "text" which allows up to 255 characters per field. This can be increased to 65.5k characters by changing the data type property to "memo".
However, when I do this, I still cannot type in more than 255 charcters. It is essential that I increase the field size as the data base is used to stoer and retrieve large amounts of descriptive text.
I think that I must be missing a trick somewhere; can any one help please ?

Thanks - Peter.

  AccessMoron 10:11 23 Feb 2005

are you entering the data directly into the table or via a form?

  emikretep 19:20 23 Feb 2005

Thanks for the response. I am entering the data directly into the form

  AccessMoron 12:18 24 Feb 2005

have you changed the format of the textbox as well as the format of the field in the table?

  emikretep 17:36 24 Feb 2005

thanks for the tip. No I haven't so I will go away and try that. Will let you know how I get on. Regards.

  emikretep 20:37 02 Mar 2005

sorted! I opened the table in design view and altered the propetries of the text boxes from "text" to "memo". That did the trick - thanks again: Peter.

  emikretep 20:38 02 Mar 2005


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017