How to limit shape data numeric value

Question

Dear community member,

I have shape data property of numeric type and I would like to limit value entered to fit some range.
F.g. if value > 100 then value = 100

Do you have some ideas?

Thanks so much for help!
Radim

Answer 1

See my ShapeSheet regarding of point 1 of my description.

What I am looking for is some solution with help of ShapeSheet only if exists...

Answer 2

Unfortunately, that explanation went right over my head. Can you try again, with more detail and without referring to C# code?

Remember, you know the context in which you are working, but we can't even see it. Things like "QUEUEMARKEREVENT" and "DEPENDSON" are probably quite clear to you, although they convey nothing to people NOT familiar with your context.

Answer 3

First of all, thank you very much for the answer.

The current situation is that we need to restrict the value of 1 property in about 5 shapes out of a total of about 100 shapes that we use in our VSTO addin.

What I know is solution with c# code in addin:

1. user data property

QUEUEMARKEREVENT("/cmd=PropertyChanged /sourceId=c795bfed-0eb7-4d80-91de-6b7c2ccdd191 /propName=MyProperty")+DEPENDSON(MyProperty)

2. handle limitation in Application_MarkerEvent by shape ID which is /sourceId parameter

I was hoping that there is something easier at the shape data level, e.g. with the use of some functions...

Answer 4

How many such validations are required? If it's s single field, such as the one in your sample, doing it the way Scott explained is the most straightforward. However, if there are different situations, or different levels for different circumstances, you'll probably want something more flexible.

GIve us the context, please.

Answer 5

Hi Radim, I will try to help.

I would do this on the form level using the After Update event of the control bound to the value and code like this:

If Me.controlname > 100 Then

Me.controlname = 100

End If

While you could use a validation rule all that can do is produce a warning message that a value less <= 100 is valid. So using code to set the value to 100 is a better option,

If you need further clarification on this feel free to ask.