Newbie Questions

Re: validate length on multi-line text box with paragraph breaks

tafavorite — Mon, 21 Mar 2011 19:11:07 GMT

I just tried this, wish someone would have commented if it had worked and it does. Hoepfully if someone comes across this they can take it that it works. I have tested it. Just set the 100 to whatever character limit you want though. But this works. thank you.

Re: validate length on multi-line text box with paragraph breaks

Albert — Thu, 03 Apr 2008 14:40:44 GMT

Hi,

Add the following validation expression on textfield: string-length(.) > 100

A newline is counted as 1 char.

Regards,

Albert

Re: validate length on multi-line text box with paragraph breaks

CraigW — Thu, 03 Apr 2008 10:11:49 GMT

Hi Clay,

No, my problem is just the opposite. I want to set a character limit on a multi-line text box but still allow paragraph breaks. InfoPath seems to have no way to do this.

Craig

Re: validate length on multi-line text box with paragraph breaks

Clay Fox — Wed, 02 Apr 2008 19:01:49 GMT

You can put character limits on fields in properties.

I was thinking you were breaking it up to get around the default limits with basic SQL connectivity. With web services you do not have that limit.

You can take a lot of data with an Nvarchar(Max) vs an Ntext.

If you need help or want to see an example of how I do it just let me know.

Re: validate length on multi-line text box with paragraph breaks

CraigW — Wed, 02 Apr 2008 16:00:22 GMT

Hi Clay,

Thanks. I really need to go the other way though. My form has many textboxes and I am sending it to a webservice then on to SQL.

I want the users to be able to enter paragraph breaks but still restrict the amount of data that they can enter, instead of letting them enter tons of data and having to use ntext columns in SQL.

Can it be done?

Thanks,

Craig

Re: validate length on multi-line text box with paragraph breaks

Clay Fox — Wed, 02 Apr 2008 14:23:39 GMT

Hi Craig Welcome to the forum.

If you need to be able to send large data types, rich text, more than the 256 character limit to SQL, I could show you how to do this. it sounds like that would solve a lot of headaches for you. Email me and I could show you.

validate length on multi-line text box with paragraph breaks

CraigW — Wed, 02 Apr 2008 08:11:23 GMT

Hi,

I need to have a multi-line text box that validates for length and allows paragraph breaks. I have seen a solution on here to use a pattern match against, e.g., ".{101,}" for a 100-character limit, however, I am finding that this technique only works if the user does not enter any paragraph breaks!

Does anyone have a solution for this that actually works? It needs to work as a single xsn for both InfoPath 2003 and 2007.

Is the general accepted approach just to make all multi-line textbox fields match against ntext in the SQL database and not enforce any length validation?

Thanks,

Craig