Thanks John for the suggestion.  I thought of it, but implementing it for the whole of Inventory module is little bit tough.   We need to introduce one more field where-ever quantity field is there [ Purchases, Pur. Returns, Sales, Sales Returns, Transfers ....]  Will be my last try, if everything else fails.

Trying to do with some coding in the itemchanged event, as suggested by Michael.   If value doesn't match with expected format, that could be rejected. 

I strongly feel that Appeon should do to improve this editmask properties.  

Happiness Always
BKR Sivaprakash

Two fields in same X/Y location but visible depending on value in another field is often a great solution. (John has my vote)

Sometimes you need to supplement visual controls with extra validation in ItemChanged. Here you can use Match  function to perform reg-ex checks on entered data if need be.

HTH /Michael

if you want to use editmask, you will have to do a modify on row change to change the editmask.  There is (was) an undocumented ability to use an expression with an editmask, but you can only set it via syntax editing (you can't see it in the datawindow editor).  If you think PB should allow editmask expressions, please enter it as a bug so that appeon will consider changing/supporting it.

for the display for rows without focus you have to use format.

use # in display format to show numbers if they are there, but not show extra zeros:  #,##0.0####

and the display format can be set as an expression if you only want to display decimal places when the value has one:

'#,##0' + if( truncate(fieldname , 0) = fieldname, '', '.0######')

An EditMask follows the control, regardless of what row you're on. So, if you have a mixture of values, the EditMask won't work for you.

Seems to me like you could use two fields, one for meters and one for numbers. Based on the units selected, make the appropriate field visible for editing. You can set the distinct EditMask for each of those fields.