Problem with Validation on Infopath 2003 form

djj66 — Tue, 16 Jun 2009 01:49:17 GMT

Hi everyone,

I have a strange intermittent problem on a form I have designed. I wonder if anyone has seen anything similar... Here's a description

I have 2 controls (@StartTime, @EndTime) in a repeating table, which are dates, displayed as times. I then use a VBScript function, to calculate the time interval between the dates as a decimal (@TripTime). I then sum @TripTime over the table to get TotalTripTime (declared control, not from table). I then have another control @TimeCarryForward which is calculated as @PreviousTime + TotalTripTime.

Everything works fine most of the time, except that just occasionally the value in @TimeCarryforward is shown with the dotted red lines around the control - as if my calculation is not recognised as a number. The calculation for @TimeCarryForward is (round(TotalTripTime * 100) / 100) + @PreviousTime

The "round" function is an attempt to avoid this problem.. It appeared to fix the problem for a certain set of problem times, but then the problem appears for another set of times. Even changing the times slighty can cause the problem to appear/go away, so I'm baffled as to what might cause this.

Has anyone seen anything similar?

thanks again,

david

Controls

Problem with Validation on Infopath 2003 form