Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / August 2007

Tip: Looking for answers? Try searching our database.

workaround "less than 50 chars" rule

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Haket - 14 May 2007 10:21 GMT
I have a text box on my Form in InfoPath 2003. The Form is connected to a
database. While updating the form I get an error message "Only text strings
less than or equal to 50 characters allowed".

What is the workaround this limitation as I want to capture more than 50
words in my text box? Any help will be much appreciated.
Ramana - 14 May 2007 11:31 GMT
Hi,

Increase the  that field length in db 50 to 256.
Then it will work for you.
Signature

k.Ramana Reddy
http://www.autonomysystems.com

> I have a text box on my Form in InfoPath 2003. The Form is connected to a
> database. While updating the form I get an error message "Only text strings
> less than or equal to 50 characters allowed".
>
> What is the workaround this limitation as I want to capture more than 50
> words in my text box? Any help will be much appreciated.
Haket - 14 May 2007 12:56 GMT
Thanks - it did work but i forgot to clarify that i was looking to submit an
unlimited lenght of texts though in practice i expect it to be around 5000
characters.  

> Hi,
>
[quoted text clipped - 7 lines]
> > What is the workaround this limitation as I want to capture more than 50
> > words in my text box? Any help will be much appreciated.
Ramana - 14 May 2007 13:22 GMT
Hi,

You can use the ritch text box instead of text box.

Using ritch box you can submit large amount of data.
Signature

k.Ramana Reddy
http://www.autonomysystems.com

> Thanks - it did work but i forgot to clarify that i was looking to submit an
> unlimited lenght of texts though in practice i expect it to be around 5000
[quoted text clipped - 11 lines]
> > > What is the workaround this limitation as I want to capture more than 50
> > > words in my text box? Any help will be much appreciated.
Haket - 14 May 2007 13:50 GMT
OK, but how do i change my Text Box to a Rich Text Box.
Trying to simply drop the Rich Text control from the window on the right
comes up with an error "A rich text box must be bound to a non repeating
field with a rich text dat type...".

i have got field defiend as a "Text" Data type with size 255.

> Hi,
>
[quoted text clipped - 17 lines]
> > > > What is the workaround this limitation as I want to capture more than 50
> > > > words in my text box? Any help will be much appreciated.
Ramana - 15 May 2007 06:19 GMT
Hi,

First change the that field data type to string data type to Rich text(Xhtml).
Then you need to right click on the text box and select change To  option
then select Rich text box.
Then text box will be changed to rich text box.

I hope this will help for you.
Signature

k.Ramana Reddy
http://www.autonomysystems.com

> OK, but how do i change my Text Box to a Rich Text Box.
> Trying to simply drop the Rich Text control from the window on the right
[quoted text clipped - 24 lines]
> > > > > What is the workaround this limitation as I want to capture more than 50
> > > > > words in my text box? Any help will be much appreciated.
Haket - 15 May 2007 12:51 GMT
I am using Access 2003 as the Database and the "Design View" does not give me
the option to change the data type to "String". Available options are "Text"
and "Memo" among other numeral and date options.

in this forum i also read that InfoPath does not allow more than 255
characters to be submitted if i am operating via DataConnection option.

i am not planning on Web Service or Shared Lipbrary option- yet at least. So
does that mean i should give up trying to get 255+ chars or is your
suggestion a workaround this?

Thanks a lot for all your help until now.

> Hi,
>
[quoted text clipped - 33 lines]
> > > > > > What is the workaround this limitation as I want to capture more than 50
> > > > > > words in my text box? Any help will be much appreciated.
Kalyan G Reddy MVP (GGK Tech) - 01 Aug 2007 16:28 GMT
Hello

The Text box has a limitation for the characters to 50, You should increse
it in the schema.

Signature

Kalyan G Reddy - INFOPATH MVP 2007
http://www.ggktech.com

> I have a text box on my Form in InfoPath 2003. The Form is connected to a
> database. While updating the form I get an error message "Only text strings
> less than or equal to 50 characters allowed".
>
> What is the workaround this limitation as I want to capture more than 50
> words in my text box? Any help will be much appreciated.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.