Format Field in Listbox

  • Thread starter Thread starter Reiner Harmgardt
  • Start date Start date
R

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
 
-----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
Click to expand...
Hi Reiner, in the format box replace fixed/standard with

0.000000000000000

Luck
Jonathan
 
Back
Top