Format Field in Listbox

[Reiner Harmgardt]

Hi NG

i am trying to format a decimal field in a listbox.
parts of the values have been brought up on the screen
like f.e. 4.1223434545454E-02.
Now i tried to format the field in the query which
prepares the data for the listbox.
but i just receive 0.04 even though i have decimals = 15
defined.
i tried fixed format or standard format.
doesn't matter.

Any idea how i could do the formatting?
Thanks for helping.

Regards

Reiner

 

[Jonathan Parminter]

-----Original Message-----
Hi NG

i am trying to format a decimal field in a listbox.
parts of the values have been brought up on the screen
like f.e. 4.1223434545454E-02.
Now i tried to format the field in the query which
prepares the data for the listbox.
but i just receive 0.04 even though i have decimals = 15
defined.
i tried fixed format or standard format.
doesn't matter.

Any idea how i could do the formatting?
Thanks for helping.

Regards

Reiner

Hi Reiner, in the format box replace fixed/standard with

0.000000000000000

Luck
Jonathan