Virtual column value different in tableview and form

[Vincent_P]

Hello, 

I have a table "Parts" where the key [REF] is a numerical value. I use a virtual column to format my ref as xxx-xxx-xxxx with this formula :  mid(number([REF])+10000000000,2,3) & "-" & mid(number([REF])+10000000000,5,3)"-" & right(number([REF])+10000000000,4).

In a table view, the value is "--6789" but in form view or when i test my formula i have "012-345-6789"

Where is the problem ?

thx for all

[Vincent_P · Accepted solution]

Ok, I finally find the problem, this is the function mid(). I rewrote the formula as this : 

mid(""&([REF]+10000000000),2,3) & "-" & mid(""&([REF]+10000000000),5,3) & "-" & right([REF]+10000000000,4)