ValuesAllowed Property - Allow a Blank

IrishGiri

I would like to allow the following values/text strings (frequencies)as input to a textbox:

40.685;26.995/27.195;27.145/40.685;446.000;49.860

When I put this string in the ValuesAllowed property of the textbox it works perfectly.

However, if at a later stage the user decides to delete the frequecncy I will have to allow for this too i.e. I need to add one more value to the string above to allow a blank value ('').

I have exhausted all possibilities to add a blank option to the string above...Navision won't accept a blank? Does anybody know how to do this?

Thanks, Paul.

Abu_Falihah

You mean you put them in the property ValuesAllowed? If this the case, just add , (comma) before your first value.. Hope it solves

IrishGiri

No good I'm afraid. Says:

'' is not a valid value

Then I try putting '';40.685;26.995/27.195;27.145/40.685;446.000;49.860
and that doesn't work either.

Seems also you have to use semicolons not commas to separate values

Abu_Falihah

Hi,

Try to put comma instead of semi colon to separate the value in your textbox's property. By the way, I use Nav 4.0 SP3.

IrishGiri

No good again I'm afraid!

Using commas doesn't work..Inputting 49.860 you get an error:

'49.860' is not a valid value. The following values can be used: 40.685,26.995/27.195,27.145/40.685,446.000,49.860.

It works with a semi-colon separated list. I just can't get it to work by adding a blank or empty string value to the ValuesAllowed string.

mart1n0

To what is the NotBlank property set, it should be set to No?

IrishGiri

NotBlank is set to No

IrishGiri

Frankly, problems like this I find very annoying....should really call this property SomeValuesAllowed !! ](*,)

IrishGiri

And I do not want to creat an option field before anyone suggests tis haha! O:)

Vineeth

hai irish,

i m waiting for an answer as well for ur question.

Well what if we dont enter any value to that field..wont it take the value as blank??? well i m just a beginner in Navision.

regards

IrishGiri

Yes it's not a problem in the beginning but.....

However, if at a later stage the user decides to delete the frequecncy I will have to allow for this too i.e. I need to add one more value to the string above to allow a blank value ('').

Abu_Falihah

OK try this one, you put it like this:

"40.685","26.995/27.195","27.145/40.685","446.000","49.860."

But then you must use EVALUATE() if you want to use this value as Integer or Decimal.

kine

And why you do not use C/AL code in OnValidate of he field to restrict the values you can enter?