Truncating data

[Steve M.]

I have a situation where I need to truncate data received in Field B from
Field A. Field A will allow up to 75 characters (via data validation) and it
populates Field B which will only hold 53 characters. I do not understand
why this has to work this way on this form, but must replicate it any way.
Any thoughts.

 

[Greg Collins [InfoPath MVP]]

Set a default value formula on Field B which is something like:

substring(FieldA, 0, 53)

--
Greg Collins [InfoPath MVP]
Visit http://www.BrainTrove.com
Visit http://www.InfoPathDev.com


I have a situation where I need to truncate data received in Field B from
Field A. Field A will allow up to 75 characters (via data validation) and it
populates Field B which will only hold 53 characters. I do not understand
why this has to work this way on this form, but must replicate it any way.
Any thoughts.

 

[Steve M.]

Thanks Mr. Collins! That worked great!