Handling large text in MS Access 2003

[barnard89]

I am using Access 2003
I have certain forms where I need to place text boxes to handle data with baout 2000 - 3000 characters long

Ideally, in a Access 2000 environment , I would be using a Rich text box to handle this issue, but in Access 2003
I cannot use a Rich text box

The general text box would handle only small data lengths
Is there any other control like Rich text box to handle and display large volume of data

 

[RoyVidar]

I thought a native Access text box is supposed to handle memofields, which can contain up to 64K characters?

I'm also lead to believe that you can use RTB also in Access, but I tend to stay away from everything that's not native controls.

Roy-Vidar

 

[JoeAtWork]

The regular text box handles any length of text. It's the data-type of the field that determines how long the text can be.

For anything over 255 characters, the data-type has to be memo. If you are in design view for a form, and drag a memo field onto the form, you will see that Access automatically creates a normal textbox (although larger than the other text data-type).

If you draw the textbox yourself, you may need to set the EnterKeyBehavior and Scroll properties so you can type in your memo field the way you would expect.