DomValue returns .E + 04 for some fields

[Sanoman]

I have got an Form, lets call it Form1. It gets that Data from Query1|Dynaset(inconsistent)| and the Form looks as follows:

1st Dataset: Calculated Data | Data to type in
2nd Dataset: Calculated Data | Data to type in
3rd ...
and so on.

In the calculated Data part of each Dataset, there is a field (Field1 ) that displays a key number for the Dataset. Its a number value that is retrieved from Query1.

For some kind of reason Field1 has sometimes the value

1E + 04

I noticed that the values which arent affected, are of order E+03. And it obviously displays 1E+04 because the highest value of Order E+4 is 14777, so all numbers of order E4 must be written as 1E + 04.
But I still dont know how to get rid of it.

Maybe someone can help me out?

 

[dcx693]

Do you mean you want the numbers to display as numbers and not in scientific notation? Change the display Format of your form control.

 

[Sanoman]

Wow cool 8)

Is solved the problem myself ... writing this thread helped me already. If anyone gets the same Problem, here's my solution. Maybe its yours too:

Solution: I changed the format of Field1, so that it can display numbers of order > 3.

The problem must have arrised from the fact that the form was a copy of another, but I changed the content of many fields ... but that didnt change their format type. That was no Problem for most fields, but Field1 was a prob.

 

[Sanoman]

@dcx693: Yeah, thats what went wrong, but it wasnt set to scientific. It displayed some values correct like 966, 962 ... but 14777 he wrote as 1E+4 ... well I dont know how to do this with the format settings, but they were obviously wrong.
Thanks for the fast reply!