Amount of characters in a field

[jds]

Hello Everybody

I wasn't sure where I should post this, so I chose here. This is a Newbie question, but I am only able to enter 255 characters in a field. The DB I have created needs a place where the individuals can enter a description of the scene they are attending. Is it possible to go any higher? Should I be using something other than a text box?

Thanx

Jason

 

[commandolomo]

It is my understanding that you can use a normal text box on the form, but in the table ensure you set the fields properties to "Memo," and not "Text".

This will enable you to use more than 255 characters.

Regards

 

[maxmangion]

as commandolomo suggested you can set the datatype to Memo. This will enable you to store up to 65,535. However, note that cannot create an index on fields with this data type.

 

[jds]

Text/Memo

Thanx guys, I thought it was going to be a simple fix. Too many codes running around in my head...steering away from the basics.

Cheers

Jason

 

[jds]

Spoke too soon

Ok guys I guess I spoke too soon. When I change the field in the table from Text to Memo, I get an error saying "too many fields defined". Does anyone know what this means?

Cheers

Jason

 

[maxmangion]

do you have an index set on the field which you are trying to change ?

 

[jds]

Install Problem

Thanks for your quick reply. After I posted my last message, I tried playing around with it on a different PC. It works just like you guys said it would on my other machine. Could it be my main computer with the DB on it has some Access install issues? I am going to try a reinstall tonight. Hopefully that will cure it...I hope.

Cheers
Jason