calculated value issue.

[Spiral]

Hello everyone,

I have a field for zip codes. This is what I have in the calculated value:

Left ( zipcode; 5) & "-" & Right ( zipcode; 4)

It works fine, except for one problem. The user can add letters which I don't want.

So I change the validation to strict data type: Numeric Only.

The Auto-Enter Calculated Value stops working.

I know calculated result must be text, but some of our users are all thumbs and WILL make mistakes.

Anyone know of a work-around?

Thanks.

[Søren Dyhr]

I suspect your autoenter to be the updating kind which allows you to do like this:

filter(theField;"0123456789")

...in the calc' behind the autoenter!

--sd

[Spiral]

Thank you very much.

[Spiral]

Hello Søren,

I setup the filter in the validation by calculation, but it's not allowing me to leave the field empty.

I don't have Not Empty checked. Any idea why this is occuring?

[Søren Dyhr]

My idea was not to use the validation at all, just massage the data into something usefull!

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000592

--sd

[Spiral]

Got it. This will work just fine. Thanks again. :(