Textbox 2048 limit!!!!! HELP

I am quite the novice at VB and VBA and am having trouble with VBA in MS Access.  I am attempting to bring togather several text fields (up to 20) into one field on a form and can't seem to get by the 2048 chr limit of the standard textbox.  I have tried a RickTextBox and that will take in the text but the contents don't show when I go to print preview or print.....  Please help

Thanks in advance
Tango7
Tango7Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mikal613Commented:
set the Multiline property to True in the Regular text box
0
Tango7Author Commented:
Mikal613,
    Thanks for the help.....  I have already looked for the multiline property on the normal textbox and unless I'm just dense as a rock, I can't find it or set it in code.  When I put this in code I got an error:   txt13.multiline = true.

Thanks again...Tango
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Mikal613Commented:
what language are you using?
0
Tango7Author Commented:
VBA in Access 2000......
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Tango7Author Commented:
m613,
   I've seen and checked these out.  Like multiline, the textbox does not have a maxlength property.  I have also tried an activex textbox and a rich textbox both found under "more controls" in design view of access.  Both have a maxlength property that I set and then all needed text fits and displays fine but in print view and on my printed form the blocks are blank.  It has me stumped and I have not been able to find a solution for either option (normal textbox or the other ones).

Thanks for your time and input....I'm just part time at this programming thing and I am confident that you experts will be able to solve this.....

T
0
Tango7Author Commented:
mikal613,
Thanks for the help....I ended up using a normal text box but had to set the EnterKeyBehavior to TRUE in code and then address the value property vs the text property when compiling my text.
Example:
textboxLetter.EnterKeyBehavior = True          ' Must act like the multiline everyone was referencing
textboxLetter.value = strUserInput                ' Text property still produced an error but value worked for large text block

Thanks again,
Tango7
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.