validation error message

[jagannalla]

Hi,

- The above image is inputbox with two variables.

Now my task is like this,

If i enter in vLB with value which is less than 15 i should get error message  " please enter the value above 15" and also if the value of vLB is greather than the vUB value then the error message should be "Please enter the value less than vUB" and vice versa for vUB.

[RSvebeck]

Hi

You can create a variable trigger which calls a macro where you can have any vailidation you like.

Like this macro (in my example, the variable name is "vTest"):

sub Validate_vTest
set v = ActiveDocument.Variables("vTest")
getVariable = v.GetContent.String
if v.GetContent.String > 5 then msgbox "Value is to high!"
end sub

// Robert Svebeck

[jagannalla]

Hi,

But this will not work out at access point. Is there any other way to achive this?

[sbaldwin]

Hi, you could do something with hidden text boxes like the attached.

Thanks

Steve

[#5]

Jagan,

Check out the attachment. It can be done thru inputbox constraints.

[jagannalla]

Kiran,

It's working fine..But if you give vInput1 greather than vInput2 it shows the erro msg "Should be greater than15" instead of "Should be less than vInput2". Can you please check once.

[#7]

Yes, its not working. I am not sure if this a bug. Alternativly you can put the error message as:

Should be greater than 15 and less than vInput2

Kiran

[jagannalla]

Right know my application is working like what you said. But, i'm trying to change the way of this.