Re: Textbox character limit length

[Marshall Barton]

I need to display a long text message in a scrollable text box that contains
around 5000 characters, but the character limit for an Access textbox is 2048.
Is there any way I can increase this limit? Or perhaps another control to do
the job?

A text box can display up tp 64K characters. You are
probably setting the text box's ControlSource property to a
constant string and the property is limited to 2K.

An alternative would be to set the text box's value using
VBA code like

strText = "this is bunch of text..." _
& "that can be longer than 2K " _
& " . . . "
Me.thetextbox = strText

 

[Marshall Barton]

Yep, well instead of using the text property, I use the value property, and
it now works!! Thanks for your help.

Right. The Value property is the default property so you
don't even need to specify Value explicitly.