Re: Textbox character limit length

  • Thread starter Thread starter Marshall Barton
  • Start date Start date
M

Marshall Barton

nigelb said:
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?
Click to expand...


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
 
nigelb said:
Yep, well instead of using the text property, I use the value property, and
it now works!! Thanks for your help.
Click to expand...


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