InfoPath Dev

Hi I'm new to all this, I have a 1 form that connects to a SQL 2005 DB.  I can retrieve and submit data.  I had to set all my Columns to nvarchar50 before the submit will work.  A limit of 50 is no good to me, I need at least 250 characters.  Does anyone have any suggestions please?

Many thanks

Hi,

You can use text box length as nvarchar256 in the db. and make text box length as 256 limit in the infopath form.

1. Double click on the text box.
2. Switch to "Display" tab.
3. Select "Limit Text box to:" check box.
4. Enter 256 in the text box field.
5. Click on ok.

Hello

To limit the characters of the text box you need to set property on the text box.

1.Open the the Properties window bt right clicking on the text box control
2.Click on 'Display' tab
3.check 'Limit text box to' check box
4.Enter the number of characters that you want to have limit on the text box i.e. 250
5.Click 'Ok'
 

Hello,

If you want to limit is minimum 250 characters then you should add validation for that field.

Add the validation like below expression,

string-length(.) < 250

Thank you for all you responses, unfortunately though none of the suggestions work.  I should mention that I am using a SQL2005 DB with InfoPath 2003. 

 I have set my column in the DB to NVARCHAR(MAX) don't have a datatype of NVARCHAR(256) limiting the box doesn't do anything.  I get the following error when attempting to insert more than 50 characters into this text box "Only Text string less than or equal to 50 characters is allowed".

 Any other suggestions please?

Thanks

I think that after changing your columns in SQL, you might have to 'refresh' your dataconnection in the form, so that the form 'knows' you now allow a longer number of characters. Have you tried selecting your main data connection in the Data Connections window, clicking 'Modify' and just walking through it again? Though you might want to change to NVARCHAR(250) or (256) instead of (MAX) -- I can't remember how IP feels about (MAX) and submit. By the way, even though NVARCHAR(250) isn't available from the drop down in the table designer in SQL Studio Manager... you should be able to just type it in....

Thanks for the reply...From what I have been reading InfoPath has too many restrictions, maybe it's may lack of SQL skills...I don't know.  Anyway I have given up and now using a Ms Access DB which works fine.

Thanks again and Merry Christmas

Just wanted to say for anyone else who may stumble upon this -- I had the same issue, and Hilary's suggestion fixed it.  Thank you!

I was having this same problem- users were complaining that they were getting validation messages when they tried to submit the form.  If you right click on the red dashed area- it would give you the pop-up stating that there is a 50 character limit.  But when you go into the text box properties- no limit was set.

After much frustration and searching all through every part of Infopath I could find- I discovered that our issue was that Access had defaulted to a 50 character limit on each field.  So the limit was invisibly transferred to Infopath.  I had to go into the database and change the limits, then go through the steps to refresh the connection as described above.  After that everything was fine. 

Easy fix after a very frustrating search for the source.... not unusual in my experience with these programs.