General

Re: Limit the number of decimals a user can enter

Jo-Anne Alfafara — Tue, 03 Apr 2012 10:56:56 GMT

Sorry - didn't see your reply above. Anyway, hope you'll find a workaround!

Re: Limit the number of decimals a user can enter

Jo-Anne Alfafara — Tue, 03 Apr 2012 10:48:21 GMT

I see - can you try Jimmy's suggestion above? Thanks!

Re: Limit the number of decimals a user can enter

eliasen — Tue, 03 Apr 2012 10:47:14 GMT

Thanks for the idea - it won't help me though. The requirement is simply not allow the user to enter the third decimal and not provide an error if she should do so.

I don't think it is doable...

Thanks

Re: Limit the number of decimals a user can enter

eliasen — Tue, 03 Apr 2012 10:44:36 GMT

Jo-Anne Alfafara:

Sorry I'm a little confused when you said "I need the data source to only contain two decimals and not just the view of the datasource". The value of your text box in the view should be the same thing stored as value in your data source, no?

Hi, and thank you for your answer.

No, the value shown in the text box isn't the same as the value in the data source. The value in the data source can be 23.456 but I can choose in the properties for the Textbox to only show to decimals.

Re: Limit the number of decimals a user can enter

Jo-Anne Alfafara — Tue, 03 Apr 2012 10:03:33 GMT

Nice Jimmy!

Re: Limit the number of decimals a user can enter

Jimmy — Tue, 03 Apr 2012 09:56:59 GMT

Hello eliasen,

The best option I can think of is to place conditional validation on the fields, so that the user will get a validation error if they enter more than 2 decimal places. Something like string-length(substring-after(., '.')) > 2 should probably do the trick. Would that work for you?

Re: Limit the number of decimals a user can enter

Jo-Anne Alfafara — Tue, 03 Apr 2012 09:38:03 GMT

Hi eliasen,

Sorry I'm a little confused when you said "I need the data source to only contain two decimals and not just the view of the datasource". The value of your text box in the view should be the same thing stored as value in your data source, no?

Limit the number of decimals a user can enter

eliasen — Tue, 03 Apr 2012 08:44:02 GMT

Hi all

InfoPath 2007 running on Forms Server 2007.

I know how to use the formatting options of a TextBox in order to only show for instance 2 decimals. But I need the data source to only contain two decimals and not just the view of the datasource. I can then use the function "round" in a rule to round to two decimals, but my customer prefers it if the user simpyl cannot enter more than two decimals in the textbox. The user will then have to round herself in case of a number with 3 decimals.

Is there anyway I can limit the number of decimals entered to only 2?

Thanks