?
Solved

Textbox 2048 limit!!!!!  HELP

Posted on 2004-11-09
8
Medium Priority
?
486 Views
Last Modified: 2011-10-03
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
0
Comment
Question by:Tango7
  • 4
  • 4
8 Comments
 
LVL 48

Expert Comment

by:Mikal613
ID: 12536790
set the Multiline property to True in the Regular text box
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 12536798
0
 

Author Comment

by:Tango7
ID: 12538592
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 48

Expert Comment

by:Mikal613
ID: 12539851
what language are you using?
0
 

Author Comment

by:Tango7
ID: 12540023
VBA in Access 2000......
0
 
LVL 48

Accepted Solution

by:
Mikal613 earned 300 total points
ID: 12540235
0
 

Author Comment

by:Tango7
ID: 12545038
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
 

Author Comment

by:Tango7
ID: 12549358
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is about my first experience with programming Arduino.
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Loops Section Overview

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question