Text Numbers Displaying in Scientific Notation?

[phmckeever]

I have a table in my db and it is formatted as text. However, there are occasions when numbers are stored in the field. When this happens, the number are displaying in scientific notation. How can I stop this from happening. Here is the actual data:

These number are typed into the field in the table:
503000005536
503000005535


The above number are stored like this:

proj_track_orphan_servers_060112​

serial_no​

5.0300000554e+011
5.0300000554e+011
5.5700020008e+011


Can you help me
phmckeever

 

[Trevor G]

Thats down to how many decimal points you can have in a field. You say the field is a text field. How does the table get populated?

Data entry from users or another source.

Can you load a sample of the database.

 

[phmckeever]

The db is populated using a data entry form, and some updates are done with queries. Sorry, because of the company's proprietary information agreement (PIA), I cannot share the db. But, the development was very simple. There is not complexity in it. Any ideas on what is going on and how to fix it. I now have records that are not showing in reporting because of this issue.

 

[Pat Hartman]

If you make the control wider, the field should display correctly. If you are looking at the table in datasheet view, drag the right edge to widen the column display.