Newbie Questions

Re: Field MUST contain a set number of characters

RegolithDev — Mon, 19 Aug 2013 13:31:41 GMT

If the fields are text boxes why not just have them self limit to a certain number of characters?

The text box limit can be accessed by selecting the field-->Properties-->Control Properties-->Display Tab--> Near the bottom of the dialog box there is a checkbox to "limit text box to" n-Characters. Try that. Might be easier than trying to match a pattern. Unless you want the fields to be able to enter more characters than necessary for security reasons, in which case, you would have to use the pattern method.

Chris
Regolith Inc.
www.regolithinc.com

Re: Field MUST contain a set number of characters

Patrick Halstead — Mon, 19 Aug 2013 00:29:49 GMT

Yay, way to go Bevan.

You're batting 1000. :)

Re: Field MUST contain a set number of characters

Zeb Ahmed — Tue, 13 Aug 2013 23:31:45 GMT

Thanks Bevan, that worked for me! Really appreciate the example as well as it helped me visualise what I needed to do :)

Re: Field MUST contain a set number of characters

Bevan S — Tue, 13 Aug 2013 21:31:37 GMT

You can do this with formatting rules, more information available here http://office.microsoft.com/en-nz/infopath-help/add-formatting-rules-HA101783371.aspx

Specifically the Data Entry Patterns section of this article.

Use the 'matches pattern' or 'does not match pattern' on the text-box control to format it (text or background colour), on another text-box control to show as an error message or to disable the submit button on the page until the pattern matches.

For example: The rule condition would be... Field1 => Does not match pattern => Custom pattern \d\d (for two digits)

Re: Field MUST contain a set number of characters

Zeb Ahmed — Tue, 13 Aug 2013 18:59:02 GMT

Hi Patrick,

a validation rule makes sense, but HOW exactly would you do it? What are the settings for ensuring people enter in TWO numbers in the box? I've read that a pattern might do it but I've never used patterns before so I'm clueless on how to make this happen.

Re: Field MUST contain a set number of characters

Patrick Halstead — Tue, 13 Aug 2013 04:53:11 GMT

How about a validation rule?

Field MUST contain a set number of characters

Zeb Ahmed — Mon, 12 Aug 2013 21:17:45 GMT

Hi all,

I have four fields that when concatenated together create a bank number.

Each field MUST have a set amount of numbers in them e.g. 12-1234-1234567-123

So:

Field1 must have 2 numbers

Field2 must have 4 numbers

and so on...

Question is, how can I make this happen? The numbers can change. They MUST be numbers (not text.) I have already set each field to their max limit, but how do I enforce that max limit?

Thanks.