Varying decimal length on the form

[vinpri]

Hello,

One of the items on my form has a value of varying length (decimals). My query is picking up the complete value but the field displays only 2 decimals. The field property is set to
Format = ##,##0.00###
Decimal = Auto

If i click on the field, it shows me the correct value e.g. 0.0001

How can i display the complete value on the form.

Thank you.

 

[t3nchi]

Hello,

One of the items on my form has a value of varying length (decimals). My query is picking up the complete value but the field displays only 2 decimals. The field property is set to
Format = ##,##0.00###
Decimal = Auto

If i click on the field, it shows me the correct value e.g. 0.0001

How can i display the complete value on the form.

Thank you.

I think in the properties section of the textbox, there's a field that says "Format". Select something like "Fixed" or "General". Then under 'Decimal', specify however many decimal places you want.

 

[vinpri]

Thank you for the reply.

The problem is that for each of the records the length of this field is different... e.g.

Record1 fld = 0.001
Record2 fld = 0.0001
Record3 fld = 0.01

So i cannot set the decimal lenght to a fixed value.

Please advice.

Thank you.

 

[Bat17]

set Format to "General Number" and leave Decimals as "Auto"

HTH

Peter